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.
MySQL installation on Linux
Moderator: General Moderators
-
Caped Knight
- Forum Commoner
- Posts: 33
- Joined: Wed Jan 01, 2003 6:20 pm
- Location: Somewhere...out there...
- mrvanjohnson
- Forum Contributor
- Posts: 137
- Joined: Wed May 28, 2003 11:38 am
- Location: San Diego, CA
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
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...
Okay. Here are the messages in order:
For tail -f mysqld.log:
For the last command:
For tail -f mysqld.log:
The only logs in messages are kernel logs dealing with my hardware, so I won't even bother copying them.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
For the last command:
[/quote]Starting MySQL: [ OK ]
- mrvanjohnson
- Forum Contributor
- Posts: 137
- Joined: Wed May 28, 2003 11:38 am
- Location: San Diego, CA
-
Caped Knight
- Forum Commoner
- Posts: 33
- Joined: Wed Jan 01, 2003 6:20 pm
- Location: Somewhere...out there...