Mysql not connecting....
Posted by mouseattack, 06-16-2006, 03:09 PM Here I was trying to change the password of the server.... right now the root password is "password' and whenever I go to phpmyadmin which I just downloaded and unzipped, i edited the config and just added the password, that is all, and it gives me this error: I for the life of me don't get what's going on here... heh.... i used yum to install mysql on a CentOS 4.3 box here's just some more output's.... [root@localhost phpmyadmin]# service mysqld restart Stopping MySQL: [ OK ] Starting MySQL: [ OK ] [root@localhost phpmyadmin]# service mysql restart mysql: unrecognized service [root@localhost phpmyadmin]# [root@localhost phpmyadmin]# mysql -u root -p Enter password: [ HERE I ENTERED "password" ] Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.20 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Anyone can help me figure out what's up, it's gotta be something super simple I just overlooked..... I feel stupid tho.... Thanks in advancez ~Mouse
Posted by fractionhosting, 06-16-2006, 04:18 PM It looks like you've already set your password to 'password' successfully, so the first thing to test would be to see if you can get to MySQL through the command line. Try the following command: mysql -u -p For example: mysql -u root -p It will then prompt you for your password. If you're able to get that far, then there is something incorrect in your PHPMyAdmin file. Post back and we'll be able to assist you further.
Posted by mouseattack, 06-16-2006, 04:23 PM mysql -u root -p works, I enter "password" when it prompts for password ,then it gives me a mysql prompt..... now what about phpmyadmin, how do I configure it for my server, centos 4.3, i copied default config.inc.php from libraries folder into main folder, updated the username and password to root and "password" and it doesn't work.... also, why doesn't this work.... [root@localhost usr]# mysqladmin flush-hosts mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' [root@localhost usr]# ANY mysqladmin command are broken for some reason, I don't understsand why~ I appreciate any and all help, i think this is the last issue and then hopefully smooth sailing!
Posted by fractionhosting, 06-16-2006, 04:36 PM For the mysqladmin issue, try adding a --user and a --password parameter on to your mysqladmin call. Since it says (Using Password: NO), that means that it is attempting to log you in as root without a password, which won't work since one is set. For phpMyAdmin, have you attempted to use the setup scripts? The latest versions have a setup script that will generate a brand new config file for you with all of the options in there. There may be one or two other items that you are missing from the default config which would be caught by using the setup wizard.
Posted by mouseattack, 06-16-2006, 04:49 PM nope, didn't work. i tried the scripts/setup.php, added server, saved, copied config.inc.php to main directory, still i get MySQL said: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) any bright ideas, what socket should it be using? maybe centos is blocking it ? you got msn/aim by any chance? i can send you url you can take a peep
Posted by joepeshi539890, 06-16-2006, 05:34 PM Ignore fractionhosting. He has no idea what he is doing. This error you are getting is common when you don't have a mysql.sock file created. ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock That will fix your problem. Then login to phpMyAdmin.
Posted by mouseattack, 06-16-2006, 06:53 PM thanks joe peshi, the guru
Posted by BluewaveHosted, 04-21-2009, 08:17 AM Hi Joe, same problem here. After running that command in SSH, I get: ln: creating symbolic link `/tmp/mysql.sock' to `/var/lib/mysql/mysql.sock': File exists The MySQL error (MySQL down) appeared this morning and now Exim stopped as well. Also, Disk /dev/md3 (/var) 100 %