MySQL Help

[Jeepsta]

I am trying to setup Apache, SSL, MySQL, and PHP via the tutorial at http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/print.html

I follow the directions for MySQL, which is first, and everything compiles and installs cleanly. When I get to the step to test and see if everything works I get an error. I run ./safe_mysqld &
and then ./mysqladmin -u root password 'new-password' as per the help file. Everything seems good but when I do a mysqlshow -p and enter my password i get this error mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Can someone help me out with this error? I looked around at the online documentation but I didnt see anything with this particular error. Any ideas?

[tminos]

Make sure ALL the mysqld, safe_mysql and what not are not running.

$ myqld
$ mysqladmin -u root password 'yourpassword'
$ mysql -u root -p mysql
<edit the grants table as you need>


Something like

GRANT * ON * TO jeepsta@localhost IDENTIFIED by 'password'

Will grant "jeepsta" access to everything (basically giving your normal user super-user control inside of mySQL)