MySQL菜鸟教程

数据库

MySQL预备知识

PHP+HTML基本语法

MySQL安装

1. CentOS安装基本命令
   参考文章：http://www.linuxidc.com/Linux/2016-09/135288.htm

wget http://dev.mysql.com/get/mysql57-community-release-el7-20.noarch.rpm
yum localinstall mysql57-community-release-el7-20.noarch.rpm
yum repolist enabled | grep "mysql.*-community.*"  #验证安装是否成功
yum install mysql-community-server  #安装MySQL
systemctl start mysqld  #启动MySQL服务
systemctl status mysqld  #查看MySQL启动状态
shell> systemctl enable mysqld
shell> systemctl daemon-reload  #开机启动
shell> grep 'temporary password' /var/log/mysqld.log
shell> mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; 
或者
mysql> set password for 'root'@'localhost'=password('MyNewPass4!'); ##修改root密码

1. MySQL登录

mysql

设置密码：

mysqladmin -u root password "new_password";

重新登录：

[root@host]# mysql -u root -p
Enter password:*******

MySQL管理

1. 启动关闭mysql
   查看状态：

systemctl status mysqld

or

ps -ef | grep mysqld

启动与关闭mysql：
启动：

cd /usr/bin
./mysqld_safe &

or

systemctl start mysqld