Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Unable to create database


Reply


4 Posts   2581 Views

Avatar
basil

Community Member, 1 Post

7 February 2009 at 8:06pm

Edited: 07/02/2009 8:07pm

Hello, I am new to SS. I have ftp'd all files over & created the write permissions on the necessary folders. After accessing the URL where I have SS installed, I receive an error regarding the database username, id/password...etc. Can you help. I need to get this install up & running by this weekend.

Does the server exist Can't find the a MySQL server on 'localhost': Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Are the access credentials correct That username/password doesn't work: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Can I access/create the database I can't create new databases and the database 'SS_mysite' doesn't exist (user 'root' doesn't have CREATE DATABASE permissions.)

I've manually created a database on my host server along w/priviledges to the user name. Also, I have tried entering this settings in the install.php and reloading via the ftp (to no avail)......HELP!!!!

Avatar
john_fuqua

Community Member, 8 Posts

28 October 2009 at 7:49am

I am having the same problem on my macbook pro. I can connect find with mysql tools and I can create databases tables and everything. I even tried using root account and it still does not work.

Has anyone figured this out?

John

Avatar
Heike-san

Community Member, 52 Posts

3 November 2009 at 1:01am

I am having the same problem as well, has someone figured out how to work this out ?
There is a slight difference for me, I have this error:

Does the server exist   Can't find the a MySQL server on 'localhost': Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Are the access credentials correct   That username/password doesn't work: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Can I access/create the database   I can't create new databases and the database 'turfcarespecialists_co_uk_db' doesn't exist (user 'pat' doesn't have CREATE DATABASE permissions.)

Avatar
john_fuqua

Community Member, 8 Posts

3 November 2009 at 1:29am

Check out this link. This helped me out to get things running.

http://lettersandscience.net/software/2009/07/how-to-install-wordpress-on-mac-os-x-leopard