How to solve problems encountered during MySQL5 Installation

The following articles mainly solve the problems encountered during MySQL5 installation. This article mainly uses code to analyze the problems related to MySQL5 installation, if you are interested in the actual operations, you can browse the following articles. 1. [root @ localhostbin] #. MySQLd_safeskip-grant-tables appears

The following articles mainly solve the problems encountered during MySQL 5 installation. This article mainly analyzes the problems related to MySQL 5 installation in code mode, if you are interested in the actual operations, you can browse the following articles. 1. [root @ localhost bin] #./MySQLd_safe skip-grant-tables appears

The following articles mainly solve the problems encountered during MySQL 5 installation. This article mainly analyzes the problems related to MySQL 5 installation in code mode, if you are interested in the actual operations, you can browse the following articles.

1. [root @ localhost bin] #./MySQLd_safe-skip-grant-tables

The following information is displayed:

 
 

  
  
Installing MySQL system tables… 
  
  
090724 12:05:13 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295 
  
  
090724 12:05:13 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295 
  
  
ERROR: 1062 Duplicate entry ‘localhost-’ for key 1 
  
  
090724 12:05:13 [ERROR] Aborting 
  
  
090724 12:05:13 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete 
  
  
Installation of system tables failed! 
  
  
Examine the logs in /var/lib/MySQL5 for more information. 
  
  
You can try to start the MySQLd daemon with: 
  
  
/usr/local/MySQL5/libexec/MySQLd –skip-grant & 
  
  
and use the command line tool 
  
  
/usr/local/MySQL5/bin/MySQL to connect to the MySQL 
  
  
database and look at the grant tables: 
  
  
http://www.knowsky.com/ 
  
  
shell> /usr/local/MySQL5/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/MySQL5 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 is the MySQL email archive. 
  
  
Please check all of the above before mailing us! 
  
  
And if you do mail us, you MUST use the /usr/local/MySQL5/bin/MySQLbug script! 
 
 

2. [root @ localhost bin] #/usr/local/MySQL5/libexec/MySQLd-skip-grant &

The following information is displayed:

 
 

  
  
[1] 6633 
  
  
[root@localhost bin]# 090724 12:05:34 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295 
  
  
090724 12:05:34 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295 
  
  
090724 12:05:34 [ERROR] Fatal error: Please read “Security” 
section of the manual to find out how to run MySQLd as root! 
  
  
090724 12:05:34 [ERROR] Aborting 
  
  
090724 12:05:34 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete 
  
  
[1]+ Exit 1 /usr/local/MySQL5/libexec/MySQLd –skip-grant 
 
 

Solution: in/etc/my. in the MySQLd section of conf, add user = MySQL. The above content describes the problems encountered during MySQL 5 installation. I hope you will get some benefits.