View previous topic :: View next topic |
Author |
Message |
jahgu n00b
Joined: 20 Jun 2002 Posts: 61 Location: Southborough, MA
|
Posted: Fri Jul 04, 2003 9:23 pm Post subject: mysql_install_db mysql problem |
|
|
hi, i'm getting the seemingly common problem
Quote: |
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
|
i've unmerged and emerge mysql and still problem exist. the one clue to my problem is when i do
Quote: |
bash-2.05b# mysql_install_db
|
i get
Quote: |
bash-2.05b# mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail
key_buffer_size=16773120
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 233979 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x82bf4f8
0x8091d15
/usr/bin/mysql_install_db: line 1: 18048 Segmentation fault /usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/usr --datadir=/var/lib/mysql --skip-innodb --skip-gemini --skip-bdb
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 family.larson.net password 'new-password'
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
bash-2.05b#
|
i'm not sure what exactly i should do. bad configuration? i only have the -fomit-frame-pointer optimization so i'm clueless as to the problem. any suggestions would be much appreciated. |
|
Back to top |
|
|
Deathwing00 Bodhisattva
Joined: 13 Jun 2003 Posts: 4087 Location: Dresden, Germany
|
Posted: Fri Jul 04, 2003 10:22 pm Post subject: |
|
|
Excuse my stupid question but... have you tried to start your mysql daemon after that? |
|
Back to top |
|
|
jahgu n00b
Joined: 20 Jun 2002 Posts: 61 Location: Southborough, MA
|
Posted: Fri Jul 04, 2003 10:31 pm Post subject: yeah |
|
|
yeah, the mysql deamon seems to start ok, at least it says it is. although, that also does funny stuff, like when i try
/etc/init.d/mysql stop
and then
/etc/init.d/mysql start // to start it again
i get
mysqld already running. i don't know, but it's really important that i get mysql working, and i'm not sure what to do. |
|
Back to top |
|
|
Deathwing00 Bodhisattva
Joined: 13 Jun 2003 Posts: 4087 Location: Dresden, Germany
|
|
Back to top |
|
|
bsolar Bodhisattva
Joined: 12 Jan 2003 Posts: 2764
|
Posted: Fri Jul 04, 2003 10:47 pm Post subject: |
|
|
Moved from Installing Gentoo. _________________ I may not agree with what you say, but I'll defend to the death your right to say it. |
|
Back to top |
|
|
|