Quote:
Originally posted by raven.sorrow
I have a slack10 distro running the stock kernel (2.4.26) the default mysql package refused to start perperly so I removed it and built mysql frrom source, this worked flawwlessly. After that I followed these commands:
Code:
/etc/rc.d/rc.mysqld start
then
Code:
su - mysql
cd /usr/local/mysql/bin
./mysql_install_db
exit
/usr/local/mysql/bin/mysqladmin -u root password 'SoMePaSs'
I got this error:
Code:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
root@biggeek:/usr/local/mysql#
/tmp/mysql.sock doesn't exist. I can create the file but what port/socket goes in the file so mysql knows how to connect to itself?
|
The 2 at the end means the mysql service isn't started. In SuSE, i use the command "rcmysql start" to start the mysql server.
Edit: my reasoning is that code 2 means mysql.sock doesn't exist. When the mysql server is started it creates the mysql.sock file. When the mysql server is stopped (e.g. when the computer is shut down) it removes it.
I am having the code 111 error like the topic starter. Attention back on this please?
I had code 111 error with SuSE 9.3 as well as 10.0. It was 'fixed' in 9.3 by manually restarting the server ("rcmysql restart") after it had automatically started at boot time. This doesn't work for SuSE 10.0.
The problem happened while I was configuring apache2 to have virtual sites. I had also used phpmyadmin to change user permissions in the mysql table.
Edit2:
In mysqld.log:
Quote:
051111 23:43:13 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibsf1v7z' (Errcode: 2)
051111 23:43:13 InnoDB: Error: unable to create temporary file; errno: 2
051111 23:43:13 [ERROR] Can't init databases
051111 23:43:13 [ERROR] Aborting
051111 23:43:13 [Note] /usr/sbin/mysqld: Shutdown complete
051111 23:43:13 mysqld ended
|
Any more thoughts?