linux mysql安装

1、linux下安装mysql，需要安装服务端和客户端

[tomcat@alipayap01_test]yum search mysql
Loaded plugins: katello, product-id, security, subscription-manager
Not root, certificate-based repositories not updated
Unable to read consumer identity
============================================== Matched: mysql ==============================================
MySQL-client.x86_64 : MySQL - Client
MySQL-server.x86_64 : MySQL: a very fast and reliable SQL database server

2、查看软件安装

rpm -ql MySQL-client.x86_64

/usr/bin/msql2mysql
/usr/bin/mysql
/usr/bin/mysql_config_editor
/usr/bin/mysql_find_rows
/usr/bin/mysql_waitpid
/usr/bin/mysqlaccess
/usr/bin/mysqlaccess.conf
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqlimport
/usr/bin/mysqlshow
/usr/bin/mysqlslap
/usr/share/doc/MySQL-client-5.6.32
/usr/share/doc/MySQL-client-5.6.32/COPYING
/usr/share/doc/MySQL-client-5.6.32/README
/usr/share/man/man1/msql2mysql.1.gz
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_config_editor.1.gz
/usr/share/man/man1/mysql_find_rows.1.gz
/usr/share/man/man1/mysql_waitpid.1.gz
/usr/share/man/man1/mysqlaccess.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqlbinlog.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlslap.1.gz

3、修改密码连接数据库初始密码在/root/.mysql_secret中

mysqladmin -uroot -plGxY7Xm_ypKlkZYa
UPDATE user SET Password=PASSWORD('123456') where USER='root' and host='root' or host='localhost';

4、配置远程机器访问mysql，默认mysql只允许本地访问

mysql -u root -p

mysql>use mysql;

mysql> select host,user from user where user='root';
+-----------+------+
| host      | user |
+-----------+------+
| 127.0.0.1 | root |
| ::1       | root |
| localhost | root |
+-----------+------+
3 rows in set (0.00 sec)

mysql>update user set host ='%' where user ='root';

mysql>flush privileges;

mysql>select host,user from user where user='root';

+------------------+------+
| host             | user |
+------------------+------+
| %                | root |
| 127.0.0.1        | root |
| ::1              | root |

+------------------+------+
3 rows in set (0.00 sec)

5、tomcat中项目连接mysql时：“Your password has expired. To log in you must change it using a client that”

mysql> select host,user,password_expired from mysql.user;
+------------------+------+------------------+
| host             | user | password_expired |
+------------------+------+------------------+
| %                | root | N                |     其他错有host允许连接
| alipayap01\_test | root | Y                |       
| 127.0.0.1        | root | Y                |     不予许本地连接 
| ::1              | root | Y                |
+------------------+------+------------------+

 

 update mysql.user set password_expired='N';  修改为N，修改后重启数据库

6、创建数据库指定编码

CREATE DATABASE `audit_staff` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci