mysql

[spur]

I'm using Feisty fawn and have installed mysql and am attempting to get it going. When I attempt to connect i het

Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Click the 'Ping' button to see if there is a networking problem

I have the server and client installed as well as the Mysql administrator and query browser. I have been trying using 'localhost' and root with no password as suggested else where. When I click on the 'test ping' button I get a positive result.

[javierrivera]

Re: mysql

What happens if you try the following command in the console?

$ sudo mysql

Are you sure that the server is runing?. You can check for it in the process manager (hit ESC+CTRL), or using the following command.

$ ps -A u | grep mysqld

BTW, pretty avatar .

Javier.

[spur]

Re: mysql

Thanks javierrivera. I get these messages when I try your suggestions.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2

Then when I check the server is running I get

6913 0.0 0.0 5036 824 pts/1 R+ 09:07 0:00 grep mysqld

I checked the server first.

[spur]

Re: mysql

Ok I've got it going now.
First I went too https://help.ubuntu.com/community/ApacheMySQLPHP
Then I checked in Adept to see if it said 'installed' for all the componants I wanted. I used copy and past to ensure no typos. I found here that apache-server had not installed on the first try, yesterday so I installed it again.
Then I added a password for root using the instructions on the previous link.
It worked! So I presume my Mysql is up and running.
I then used Kmyadmin to add a user and all is well.
Now for the next steps!