centos7下安装mysql

一 安装mysql

1 首先强力删除mysql

http://blog.csdn.net/typa01_kk/article/details/49057073

2 依次执行如下命令安装mysql

# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm 
# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-community-server

二 安装设置

1 启动mysql客户端

[root@centos opt]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

2 修改管理员密码

[root@centos opt]# mysqladmin -u root password 此处填写密码
Warning: Using a password on the command line interface can be insecure.

3 再次登录

[root@centos opt]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.6.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

4 其他登录方式

[root@centos opt]# mysql -uroot -hlocalhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.38 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> quit;

三 相关命令

[root@centos opt]# systemctl status mysqld
[root@centos opt]# systemctl stop mysqld
[root@centos opt]# systemctl start mysqld
[root@centos opt]# systemctl restart mysqld

四 参考 

http://blog.csdn.net/cds86333774/article/details/51132532

http://blog.csdn.net/donglynn/article/details/49996817

http://blog.csdn.net/selifecn/article/details/72820327

http://blog.csdn.net/hbtj_1216/article/details/53956108

http://blog.csdn.net/typa01_kk/article/details/49057073

http://blog.csdn.net/hbtj_1216/article/details/53956108

http://blog.csdn.net/markboo/article/details/50482792