yum的方式安装mysql_Centos7 Yum方式安装Mysql7

MySQL数据库设置

首先启动MySQL

[root@localhost ~]# systemctl start mysqld.service

查看MySQL运行状态，运行状态如

[root@localhost ~]# systemctl status mysqld.service

如下命令进入数据库(注：首次登陆是不需要密码的)：

[root@localhost ~]# mysql -uroot -p

输入初始密码，此时不能做任何事情，因为MySQL默认必须修改密码之后才能操作数据库：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

这时候我遇到一个问题，事先安装过低版本，现在直接安装高版本，报错：

I recently had my MySQL server upgraded from 5.1 to 5.7and I'm trying to upgrade my databases using mysql_upgrade but I keep getting this error:

解决方法：

简单粗暴，直接回车(由于还未设置初始密码，所有直接回车即可)

mysql_upgrade -u root -p

Enter password:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'

wp_commentmeta                               OK

wp_comments                                  OK

wp_links                                     OK

wp_options                                   OK

wp_postmeta                                  OK

wp_posts                                     OK

wp_term_relationships                        OK

wp_term_taxonomy                             OK

wp_terms                                     OK

wp_usermeta                                  OK

wp_users                                     OK

mysql.columns_priv                                 OK

mysql.db                                           OK

mysql.event                                        OK

mysql.func                                         OK

mysql.general_log                                  OK

mysql.help_category                                OK

mysql.help_keyword                                 OK

mysql.help_relation                                OK

mysql.help_topic                                   OK

mysql.host                                         OK

mysql.ndb_binlog_index                             OK

mysql.plugin                                       OK

mysql.proc                                         OK

mysql.procs_priv                                   OK

mysql.servers                                      OK

mysql.slow_log                                     OK

mysql.tables_priv                                  OK

mysql.time_zone                                    OK

mysql.time_zone_leap_second                        OK

mysql.time_zone_name                               OK

mysql.time_zone_transition                         OK

mysql.time_zone_transition_type                    OK

mysql.user                                         OK

Running 'mysql_fix_privilege_tables'...      OK