Page 1 of 1

MySQL installation on Linux

Posted: Mon Aug 04, 2003 3:23 pm
by Caped Knight
I installed MySQL from first installation on RedHat 8. Now when I try to start up safe_mysqld I get this:

Starting mysqld daemon with databases from /var/lib/mysql
030804 14:16:40 mysqld ended


So now when I try to change my root password with mysqladmin 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!



Can someone please help me? Linux drives my up the freaking wall.

Posted: Mon Aug 04, 2003 3:43 pm
by mrvanjohnson
Could use a little more information. Start up 3 terminal windows.

In one Window go to your logs directory and do a tail -f mysqld.log
In the other Window go to your logs directory and do a tail -f messages
And in the last terminal window do a service mysqld start

Wait for output in the two log files. Look for error messages and post them

Posted: Mon Aug 04, 2003 4:47 pm
by Caped Knight
Okay. Here are the messages in order:


For tail -f mysqld.log:
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
030804 14:16:40 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030804 14:16:40 mysqld ended
The only logs in messages are kernel logs dealing with my hardware, so I won't even bother copying them.

For the last command:
Starting MySQL: [ OK ]
[/quote]

Posted: Mon Aug 04, 2003 4:55 pm
by mrvanjohnson
I think it needs that './mysql/host.frm' file. You might want to try just touching that file for now to see if it starts. On my server (RH 8 ) that file is located in the following path /var/lib/mysql/mysql/host.frm

So simple su and do a touch /var/lib/mysql/mysql/host.frm

Hope this helps

Posted: Mon Aug 04, 2003 4:59 pm
by Caped Knight
Thank you very, very much for the help. I guess I won't be finding out how well it works any time soon, though, since RedHat decided to screw up PHP and Apache in every way possible. =/