【mysql】配置MySQL，解决安装过程中的问题

在文章&＃xff0c;Centos6.2中mysql的安装与配置中&＃xff0c;使用yum的方式安装了mysql 。再次安装的时候跟系统的环境有关系&＃xff0c;遇到了不少问题。记录一下。

  yum 安装 出错 Error: Protected multilib versions:

  file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.1.73-8.el6_8.x86_64 conflicts with   file from package MySQL-client-5.5.48-1.linux2.6.i386
  file /usr/share/man/man1/mysqlslap.1.gz from install of mysql-5.1.73-8.el6_8.x86_64 conflicts with   file from package MySQL-client-5.5.48-1.linux2.6.i386

  解决方案&＃xff1a;rpm -e mysql-server-5.1.73-8.el6_8.x86_64 --nodeps

  170721 22:25:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  /usr/libexec/mysqld: Table &＃39;mysql.plugin&＃39; doesn&＃39;t exist
  170721 22:25:03 [ERROR] Can&＃39;t open the mysql.plugin table. Please run mysql_upgrade to create it.
  170721 22:25:03  InnoDB: Initializing buffer pool, size &＃61; 8.0M
  170721 22:25:03  InnoDB: Completed initialization of buffer pool
  InnoDB: The log sequence number in ibdata files does not match
  InnoDB: the log sequence number in the ib_logfiles!
  170721 22:25:03  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  170721 22:25:03  InnoDB: Started; log sequence number 0 1595675
  170721 22:25:03 [ERROR] Fatal error: Can&＃39;t open and lock privilege tables: Table &＃39;mysql.host&＃39; doesn&＃39;t exist
  170721 22:25:03 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  170721 22:25:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  /usr/libexec/mysqld: Table &＃39;mysql.plugin&＃39; doesn&＃39;t exist
170721 22:25:24 [ERROR] Can&＃39;t open the mysql.plugin table. Please run mysql_upgrade to create it.
  170721 22:25:24  InnoDB: Initializing buffer pool, size &＃61; 8.0M
  170721 22:25:24  InnoDB: Completed initialization of buffer pool
  InnoDB: The log sequence number in ibdata files does not match
  InnoDB: the log sequence number in the ib_logfiles!
  170721 22:25:24  InnoDB: Database was not shut down normally!
  InnoDB: Starting crash recovery.
  InnoDB: Reading tablespace information from the .ibd files...
  InnoDB: Restoring possible half-written data pages from the doublewrite
  InnoDB: buffer...
  170721 22:25:24  InnoDB: Started; log sequence number 0 1595675
  170721 22:25:24 [ERROR] Fatal error: Can&＃39;t open and lock privilege tables: Table &＃39;mysql.host&＃39; doesn&＃39;t exist
  170721 22:25:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  170721 22:25:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  /usr/libexec/mysqld: Table &＃39;mysql.plugin&＃39; doesn&＃39;t exist
170721 22:25:37 [ERROR] Can&＃39;t open the mysql.plugin table. Please run mysql_upgrade to create it.

  安装完启动的时候遇到上述问题。

  解决方案&＃xff1a;rm -rf /var/lib/mysql

 登陆mysql

  [root&＃64;root opt]# mysql -u root password fxq123
  mysqladmin: connect to server at &＃39;localhost&＃39; failed
  error: &＃39;Access denied for user &＃39;root&＃39;&＃64;&＃39;localhost&＃39; (using password: NO)&＃39;

  ERROR 1045 (28000): Access denied for user &＃39;root&＃39;&＃64;&＃39;localhost&＃39; (using password: YES)

  解决方案&＃xff1a;使用mysql -uroot -proot
 一旦登录之后&＃xff0c;可以修改用户的账号和密码&＃xff0c;

  查看用户授权表&＃xff1a;select user,host,password from mysql.user;

  给用户设置密码&＃xff1a;update mysql.user set password&＃61;PASSWORD(&＃39;root&＃39;) where user&＃61;&＃39;root&＃39;;

             flush privileges;