[SOLVED] Problem with install MySQL some error message when install

H20 · 2011-07-02 12:55:27

hi
i got some problem with install MySQL, i following by wiki - https://wiki.archlinux.org/index.php/MySQL, but when i try install mysql i get afterinstalation message

Installing MySQL system tables...
110702 13:36:38 [ERROR] /usr/bin/mysqld: unknown option '--skip-locking'
110702 13:36:38 [ERROR] Aborting

110702 13:36:38 [Note] /usr/bin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/bin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:Installing MySQL system tables...
110702 13:36:38 [ERROR] /usr/bin/mysqld: unknown option '--skip-locking'
110702 13:36:38 [ERROR] Aborting

110702 13:36:38 [Note] /usr/bin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/bin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/scripts/mysqlbug script!


    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/scripts/mysqlbug script!

so i think this is reason why i cant start mysqld. i realy dont know why i have this problem, i try remove mysql (pacman -Rdd mysql) but nothing hapened. Other problem is file mysqld.sock is not in the system, dosen exist , and this file is required to work MySQL, i now should be created on ferst start mysql server but nothing... anywy i have firs solved problem with correctly instalation...
Any idea ??
thanks for any help

Last edited by H20 (2011-07-04 21:02:33)

Spider.007 · 2011-07-03 09:27:02

Search on these forums for "mysql skip-locking" and you should find the answer. The problem lies in an old mysql configuration file in /etc or your homedir with the renamed 'skip-locking' flag in it.

H20 · 2011-07-04 15:13:55

Spider.007 - many thanks, its so helpful for me... i find in /etc file my.cnf, i think this file is stay there after old instalation of MySQL , so i dont know why pacman dosent remove this file when i uninstall MySQL about 1,5 yare ago, anyway THANK

Arch Linux

#1 2011-07-02 12:55:27

[SOLVED] Problem with install MySQL some error message when install

#2 2011-07-03 09:27:02

Re: [SOLVED] Problem with install MySQL some error message when install

#3 2011-07-04 15:13:55

Re: [SOLVED] Problem with install MySQL some error message when install

Board footer