Donald D Henson wrote:
G T Smith wrote: Donald D Henson wrote:
Donald D Henson wrote:
I'm not a newbie on computers in general but I am a complete newbie on MySQL. I installed MySQL as part of the xampp install kit for Linux. Everything seemed to go well and the test routines seemed to be passing. I then assigned a (MySQL) root password and everything ground to a halt. I started getting the famous "Error 2002 (HY000)) which basically means nothing can connect. I'm looking for a kind person willing to assist in locating, fixing, and explaining the bug here, even if the bug is me. I've spent quite a bit of time trying a few things I found in Appendix B of the user manual to very little effect. Bottom line? I'm thoroughly confused and need assistance. If you are interested, contact me off-list at wepin@wepin.com. Thanks for your time.
Don, Just a guess, but after assigning the root password, can you access mysql from a konsole window (command line) using: mysql -u root -p After hitting return you will be prompted for the password. The mysql root password is not/does not have to be the linux box root password. If you can access mysql giving the root password, my guess is that you will need to create a user for xampp to access mysql with (probably xampp). It will be in the xampp docs. Remember, http://dev.mysql.com/doc/refman/5.0/en/index.html is your friend. But a quick hack at setting up users is: see: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html mysql -u root mysql> use mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); SET PASSWORD FOR 'root'@'hostname' = PASSWORD('newpwd'); **SET PASSWORD FOR 'root'@'hostname.domain' = PASSWORD('newpwd'); SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd'); **optional hostname statements confirm: mysql> select host, user, password from user; setting up users: (note, the following sets up additional super users, adjust as required) GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; **GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname.domain' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'user'@'127.0.0.1' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; updating password for existing users mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd') WHERE User = 'root'; mysql> FLUSH PRIVILEGES; mysql> exit To quit. To browse/edit mysql from a great gui in kde/gnome, install mysql-gui-tools it will help you with the mysql learning curve. mysql is really pretty easy once you make friends with the quirky syntax. -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org