| Bug #49798 | Bug to install mysql | ||
|---|---|---|---|
| Submitted: | 18 Dec 2009 9:18 | Modified: | 18 Dec 2009 9:47 |
| Reporter: | mickael Lmns | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 5.1.41 | OS: | Linux (Debian) |
| Assigned to: | CPU Architecture: | Any | |
[18 Dec 2009 9:21]
Sveta Smirnova
Thank you for the report. Please check if you have option skip-bdb in your configuration file. Try mysql_install_db --no-defaults and see if ti helps.
[18 Dec 2009 9:36]
mickael Lmns
ok thank you for your help options --no-defaults work . but i have other problem sable:/usr/local/mysql# scripts/mysql_install_db --no-defaults Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h sable password 'new-password' Alternatively you can run: ./bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd ./mysql-test ; perl mysql-test-run.pl Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available at http://www.mysql.com/ Support MySQL by buying support/licenses from http://shop.mysql.com/ sable:/usr/local/mysql# bin/mysqla mysqlaccess mysqladmin sable:/usr/local/mysql# bin/mysqla mysqlaccess mysqladmin sable:/usr/local/mysql# bin/mysqladmin -u root password root 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! sable:/usr/local/mysql# bin/mysqld mysqld mysqld-debug mysqld_multi mysqld_safe mysqldump mysqldumpslow sable:/usr/local/mysql# bin/mysqld_safe & [1] 32319 sable:/usr/local/mysql# 091218 10:32:52 mysqld_safe Logging to '/var/lib/mysql/sable.err'. 091218 10:32:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 091218 10:32:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended sable:/usr/local/mysql# [1]+ Done bin/mysqld_safe sable:/usr/local/mysql# sable:/usr/local/mysql# sable:/usr/local/mysql# sable:/usr/local/mysql# bin/mysqladmin -u root password root 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! sable:/usr/local/mysql# ps -ef |grep mysql root 32492 18909 0 10:33 pts/2 00:00:00 grep mysql You have a suggestion ? Thank
[18 Dec 2009 9:47]
Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is most likely not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Please read at http://dev.mysql.com/doc/refman/5.1/en/mysqld-safe.html about how to use mysqld_safe. Reason why mysqld refused to start most likely written to file /var/lib/mysql/sable.err Thank you for your interest in MySQL.
[26 Mar 2011 20:07]
Larry D. Wilson
This is an issue at least in mysql-5.5.10-linux2.6-x86_64.tar. An out of the box install:
root@<ipinfo>:/usr/local/mysql# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...
Installation of system tables failed! Examine the logs in
/my-data/mysql/data for more information.
You can try to start the mysqld daemon with:
shell> /usr/local/mysql/bin/mysqld --skip-grant &
and use the command line tool /usr/local/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /my-data/mysql/data 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/local/mysql/scripts/mysqlbug script!
And this succeeds:
root@<ipinfo>:/usr/local/mysql# scripts/mysql_install_db --user=mysql --no-defaults
Description: Hello , I have a bug when i install mysql on linux debian , compilation good finish . When i execut this command : scripts/mysql_install_db --basedir=/usr/local/mysql/ --user=mysql I obtain : 091218 10:12:47 [ERROR] /usr/local/mysql//bin/mysqld: unknown option '--skip-bdb' 091218 10:12:47 [ERROR] Aborting 091218 10:12:47 [Note] /usr/local/mysql//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/local/mysql//bin/mysqld --skip-grant & and use the command line tool /usr/local/mysql//bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql//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. The latest information about MySQL is available on the web at http://www.mysql.com/. 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/local/mysql//scripts/mysqlbug script! Since two days i compile and recompile but not success. If you have a idea How to repeat: Hello , I have a bug when i install mysql on linux debian , compilation good finish . When i execut this command : scripts/mysql_install_db --basedir=/usr/local/mysql/ --user=mysql I obtain : 091218 10:12:47 [ERROR] /usr/local/mysql//bin/mysqld: unknown option '--skip-bdb' 091218 10:12:47 [ERROR] Aborting 091218 10:12:47 [Note] /usr/local/mysql//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/local/mysql//bin/mysqld --skip-grant & and use the command line tool /usr/local/mysql//bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql//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. The latest information about MySQL is available on the web at http://www.mysql.com/. 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/local/mysql//scripts/mysqlbug script! Since two days i compile and recompile but not success. If you have a idea