centos安装MySQL

[root@yl-web yl]# mysql -u root 

官网下载安装mysql-server

# 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

安装成功后重启mysql服务。

# service mysqld restart

初次安装mysql，root账户没有密码。

[root@yl-web yl]# mysql -u root 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

设置密码
 
 

  
  
mysql> set password for 'root'@'localhost' =password('password');
Query OK, 0 rows affected (0.00 sec)
  
  


  
  
下次再次进入mysql
  
  
 mysql -u root -p 即可进入mysql命令行

  
  


  
  


 
 

配置mysql
1、编码
mysql配置文件为/etc/my.cnf
最后加上编码配置
 
 

  
  
[mysql]
default-character-set =utf8
 
 

开启远程连接

在mysql控制台执行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;