View previous topic :: View next topic |
Author |
Message |
Kronos Tux's lil' helper
Joined: 05 Sep 2002 Posts: 116 Location: St. Louis area (Wood River, IL)
|
Posted: Fri Nov 01, 2002 10:40 am Post subject: mysql probs - anyone help? |
|
|
>mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
server is running, /var/run/mysqld/mysqld.sock exists. don't know what problem is... |
|
Back to top |
|
|
sebest Apprentice
Joined: 03 Jul 2002 Posts: 163 Location: Paris - France
|
Posted: Fri Nov 01, 2002 4:20 pm Post subject: |
|
|
Did you check that the file mysqld.sock is really a socket and not a regular file?
You could try to connect by tcp/ip on localhost |
|
Back to top |
|
|
Kronos Tux's lil' helper
Joined: 05 Sep 2002 Posts: 116 Location: St. Louis area (Wood River, IL)
|
Posted: Sat Nov 02, 2002 12:16 am Post subject: |
|
|
>>You could try to connect by tcp/ip on localhost
How would I go about doing that.
/var/run/mysqld/mysqld.sock is the file
I have ls using color, and it is a pinkish/purplish color. If that means anything. |
|
Back to top |
|
|
rac Bodhisattva
Joined: 30 May 2002 Posts: 6553 Location: Japanifornia
|
Posted: Sat Nov 02, 2002 2:19 am Post subject: |
|
|
Kronos wrote: | >>You could try to connect by tcp/ip on localhost
How would I go about doing that. |
Code: | $ mysql -h [your IP address] |
...I just tried it with "-h localhost" and it wanted to use the Unix socket. Do you have support for Unix domain sockets in your kernel? Code: | $ dmesg | grep socket | ...should tell you if you are unsure. _________________ For every higher wall, there is a taller ladder |
|
Back to top |
|
|
Tahoe n00b
Joined: 08 Oct 2002 Posts: 8
|
Posted: Sun Nov 03, 2002 1:59 pm Post subject: |
|
|
I get the exact same error. The problem is that mysqld is not running (well at least for me).
Code: | /etc/init.d/mysqld start | gives no errors but do a Code: | ps -ef | grep mysqld | and you will probably see that mysqld is not running. I do a and get
Quote: | Starting mysqld daemon with databases from /var/lib/mysql
021103 03:59:25 mysqld ended
| which means that mysqld starts and then immediatly stops. Now this is where I am stumped. I do have the database set up in /var/lib/mysql wich was created with the emerge scripts. I have also tried both 3.23.52-r1 and 3.23.53 and get the same result. |
|
Back to top |
|
|
arkane l33t
Joined: 30 Apr 2002 Posts: 918 Location: Phoenix, AZ
|
Posted: Sun Nov 03, 2002 4:13 pm Post subject: |
|
|
Does the /var/log/mysql/mysql.err or /var/log/mysql/mysql.log file have anything in particular?
not much to shoot for, but worth a look. |
|
Back to top |
|
|
Tahoe n00b
Joined: 08 Oct 2002 Posts: 8
|
Posted: Sun Nov 03, 2002 4:37 pm Post subject: |
|
|
I get the following error when running mysqld:
Quote: | 021103 6:42:26 mysqld: Table 'mysql.host' doesn't exist |
I think the problem is related to the mysql_install_db where I get:
Quote: | Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
ERROR: 1033 Incorrect information in file: './mysql/db.frm'
021103 6:43:34 /usr/sbin/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/etc/init.d/mysql start (you have to start the server first!)
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h bgp password 'new-password'
See the manual for more instructions.
|
|
|
Back to top |
|
|
|