Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql probs - anyone help?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
Kronos
Tux's lil' helper
Tux's lil' helper


Joined: 05 Sep 2002
Posts: 116
Location: St. Louis area (Wood River, IL)

PostPosted: Fri Nov 01, 2002 10:40 am    Post subject: mysql probs - anyone help? Reply with quote

>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
View user's profile Send private message
sebest
Apprentice
Apprentice


Joined: 03 Jul 2002
Posts: 163
Location: Paris - France

PostPosted: Fri Nov 01, 2002 4:20 pm    Post subject: Reply with quote

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
View user's profile Send private message
Kronos
Tux's lil' helper
Tux's lil' helper


Joined: 05 Sep 2002
Posts: 116
Location: St. Louis area (Wood River, IL)

PostPosted: Sat Nov 02, 2002 12:16 am    Post subject: Reply with quote

>>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
View user's profile Send private message
rac
Bodhisattva
Bodhisattva


Joined: 30 May 2002
Posts: 6553
Location: Japanifornia

PostPosted: Sat Nov 02, 2002 2:19 am    Post subject: Reply with quote

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
View user's profile Send private message
Tahoe
n00b
n00b


Joined: 08 Oct 2002
Posts: 8

PostPosted: Sun Nov 03, 2002 1:59 pm    Post subject: Reply with quote

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
Code:
safe_mysqld
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
View user's profile Send private message
arkane
l33t
l33t


Joined: 30 Apr 2002
Posts: 918
Location: Phoenix, AZ

PostPosted: Sun Nov 03, 2002 4:13 pm    Post subject: Reply with quote

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
View user's profile Send private message
Tahoe
n00b
n00b


Joined: 08 Oct 2002
Posts: 8

PostPosted: Sun Nov 03, 2002 4:37 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum