MySQL doesn't work

pppaaarrrkkk · 02-20-2008, 09:13 PM

Hello Linuxquestions people.

I've got MySQL on Fedora 6. Doesn't work. (f**@~~### etc..etc..)

If I type

$ mysqladmin ping

it says :

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost qqq]#

Any ideas please ?

billymayday · 02-20-2008, 09:21 PM

Did you start mysql?

service mysqld start from the command line

If already started, does /var/lib/mysql/mysql.sock' exist?

bigrigdriver · 02-20-2008, 09:38 PM

Here is a quickstart guide to MySQL. Pass over the introduction, installation, and configuration to get to Getting Started. The information there may prove helpful. There is even a default root password that I didn't know about until I read this.
http://www.spikesource.com/docs/cs_1...tartguide.html

jschiwal · 02-20-2008, 11:09 PM

Older versions of mysql packages supplies the mysql manual. On the most recent, you need to download it yourself. Make sure to read the section about securing the database. You may want to drop a test table. Also change the root user settings.

On Fedora 6 you can probably use chkconfig to start the database the first time and set it up so that it starts automatically in runlevels 3 & 5 the next time you reboot.

billymayday · 02-21-2008, 12:40 AM

No - you still need to start the service as I said above. Chkconfig will start it on boot (ie you really need to do both - start for this session and chkconfig for future sessions)