mysql -HELP!!!
- Started
- Last post
- 27 Responses
- Dancer
Very new to this so be gentle: I added a Password using PHPMyAdmin but once I added I could no longer access the admin.
I went into config.ini.php to add the password in there but no joy.
the error message I get is "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) "
Also my "http://localhost" has renamed itself http://rockstar.home anyone know how or why this has happened?
Thanks
- stupidresponse0
the mysql socket file is in a location that mysql does not have priviledges to access
- Dancer0
So where would I find this file and how would I fix it?
- stupidresponse0
is this on a mac? or a linux box?
- Dancer0
mac
- stupidresponse0
open terminal and type:
ps xa | grep mysqld
- Dancer0
this is what I get:
4993 p1 S+ 0:00.00 grep mysqld
- stupidresponse0
i don't think mysql server is running
- Dancer0
Well I tried to turn it off and on again but when I went to turn it of using MySQL in the Preferences it said "could not turn off internal error". Is there another way to turn it on/off perhaps using terminal?
- stupidresponse0
well it's off, there's no mysql process running on your machine
- Dancer0
So how would I turn it on again using terminal?
- stupidresponse0
it depends on where mysql is installed on your machine. what install of mysql is this? is it from entropy? darwinports?
- Dancer0
entropy
- stupidresponse0
try:
cd /usr/local/mysql
- Dancer0
[macintosh:~] alistair% cd /usr/local/mysql
[macintosh:/usr/local/mysql] alistair%
- stupidresponse0
ok. type:
sudo echo
it will ask for your user password (alistair's, not mysql's) then:
sudo ./bin/mysqld_safe &
- Dancer0
[macintosh:/usr/local/mysql] alistair% sudo echo
WARNING: Improper use of the sudo command could lead to data loss
or the deletion of important system files. Please double-check your
typing when using sudo. Type "man sudo" for more information.To proceed, enter your password, or type Ctrl-C to abort.
Password:
[macintosh:/usr/local/mysql] alistair% sudo ./bin/mysqld_safe &
[1] 5871
[macintosh:/usr/local/mysql] alistair% Starting mysqld daemon with databases from /usr/local/mysql/data
- stupidresponse0
ok, mysql should be running now
- Dancer0
Ok so now mysql has started this is the error that kicks up when I point the browser to PHPmyAdmin:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Now I believe I had to change the config.ini.php password but for some reason it does not work.
- Dancer0
is there a way to reset the password and try again.?