MySQL installation on Linux

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Caped Knight
Forum Commoner
Posts: 33
Joined: Wed Jan 01, 2003 6:20 pm
Location: Somewhere...out there...

MySQL installation on Linux

Post 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.
User avatar
mrvanjohnson
Forum Contributor
Posts: 137
Joined: Wed May 28, 2003 11:38 am
Location: San Diego, CA

Post 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
Caped Knight
Forum Commoner
Posts: 33
Joined: Wed Jan 01, 2003 6:20 pm
Location: Somewhere...out there...

Post 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]
User avatar
mrvanjohnson
Forum Contributor
Posts: 137
Joined: Wed May 28, 2003 11:38 am
Location: San Diego, CA

Post 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
Caped Knight
Forum Commoner
Posts: 33
Joined: Wed Jan 01, 2003 6:20 pm
Location: Somewhere...out there...

Post 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. =/
Post Reply