mysql学习-安装

一、mysql安装包解压，注意下载的mysql包必须与操作系统版本需求一致。
[root@node1 soft]# ls
mysql-5.7.11-1.el5.i686.rpm-bundle.tar
[root@node1 soft]# ls -l
total 600552
-rw-r--r-- 1 root root 614359040 Feb 18 12:02 mysql-5.7.11-1.el5.i686.rpm-bundle.tar
[root@node1 soft]# tar -xvf mysql-5.7.11-1.el5.i686.rpm-bundle.tar 
mysql-community-libs-5.7.11-1.el5.i686.rpm
mysql-community-common-5.7.11-1.el5.i686.rpm
mysql-community-libs-compat-5.7.11-1.el5.i686.rpm
mysql-community-server-5.7.11-1.el5.i686.rpm
mysql-5.7.11-1.el5.i686.rpm
mysql-community-test-5.7.11-1.el5.i686.rpm
mysql-community-devel-5.7.11-1.el5.i686.rpm
mysql-community-client-5.7.11-1.el5.i686.rpm
mysql-community-embedded-5.7.11-1.el5.i686.rpm
mysql-community-embedded-devel-5.7.11-1.el5.i686.rpm
二、安装mysql
[root@node1 soft]# rpm -ivh mysql-community-server-5.7.11-1.el5.i686.rpm 
warning: mysql-community-server-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 


5072e1f5
error: Failed dependencies:
        mysql-community-client = 5.7.11-1.el5 is needed by mysql-community-server-5.7.11-1.el5.i686
        mysql-community-common = 5.7.11-1.el5 is needed by mysql-community-server-5.7.11-


1.el5.i686
[root@node1 soft]# rpm -ivh mysql-community-server-5.7.11-1.el5.i686.rpm --force --nodeps
warning: mysql-community-server-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 


5072e1f5
Preparing...                ########################################### [100%]
   1:mysql-community-server ########################################### [100%]
[root@node1 soft]# 
[root@node1 soft]# 


--mysql会自动添加mysql用户
[root@node1 soft]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
[root@node1 soft]# ls -l
total 1201144
-rw-r--r-- 1 7155 wheel     40516 Feb  2 17:27 mysql-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 root root  614359040 Feb 18 12:02 mysql-5.7.11-1.el5.i686.rpm-bundle.tar
-rw-r--r-- 1 7155 wheel  32644512 Feb  2 17:31 mysql-community-client-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel    825859 Feb  2 17:31 mysql-community-common-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel   5402990 Feb  2 17:31 mysql-community-devel-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel  53512687 Feb  2 17:31 mysql-community-embedded-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 168617172 Feb  2 17:31 mysql-community-embedded-devel-5.7.11-


1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel   2968131 Feb  2 17:32 mysql-community-libs-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel   2172050 Feb  2 17:32 mysql-community-libs-compat-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 209431525 Feb  2 17:33 mysql-community-server-5.7.11-1.el5.i686.rpm
-rw-r--r-- 1 7155 wheel 138730825 Feb  2 17:34 mysql-community-test-5.7.11-1.el5.i686.rpm
三、安装msql client
[root@node1 soft]# rpm -ivh mysql-community-client-5.7.11-1.el5.i686.rpm
warning: mysql-community-client-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 


5072e1f5
error: Failed dependencies:
        mysql-community-libs = 5.7.11-1.el5 is needed by mysql-community-client-5.7.11-1.el5.i686
[root@node1 soft]# rpm -ivh mysql-community-client-5.7.11-1.el5.i686.rpm --force --nodeps
warning: mysql-community-client-5.7.11-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 


5072e1f5
Preparing...                ########################################### [100%]
   1:mysql-community-client ########################################### [100%]
[root@node1 soft]# 


四、停止mysql
[root@node1 soft]# mysql
ERROR 1045 (28000): Unknown error 1045
[root@node1 soft]# /etc/rc.d/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@node1 soft]# netstat -anp|grep 3306


五、使用mysql安全登陆，修改root账号密码
[root@node1 ~]# mysqld_safe --skip--tables &
[1] 5379
[root@node1 ~]# Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
grep: write error: Broken pipe
2016-02-29T19:40:08.792329Z mysqld_safe Logging to '/var/log/mysqld.log'.
2016-02-29T19:40:08.861817Z mysqld_safe A mysqld process already exists


[1]+  Exit 1                  mysqld_safe --skip--tables
[root@node1 ~]# 



/var/lib/mysql


[root@node1 ~]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.11 MySQL Community Server (GPL)


Copyright (c) 2000, 2016, 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> select rurrent_user;
ERROR 1054 (42S22): Unknown error 1054
mysql> 
mysql> use mysql
Database changed
mysql> 
mysql> 
mysql> update mysql.user set authentication_string=password('root') where user='root';
Query OK, 0 rows affected, 1 warning (0.00 sec)


mysql>  FLUSH PRIVILEGES; 
Query OK, 0 rows affected (0.00 sec)


mysql> quit
Bye
[root@node1 ~]# /etc/init.d/mysql restart 
-bash: /etc/init.d/mysql: No such file or directory
[root@node1 ~]# /etc/rc.d/init.d/mysqld start
Starting mysqld:                                           [  OK  ]
[root@node1 ~]# 




--登陆使用命令报错，需要关闭validate_password = OFF
[root@node1 ~]# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.11


Copyright (c) 2000, 2016, 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> create database test;
ERROR 1820 (HY000): Unknown error 1820
mysql> 
[root@node1 etc]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.11

Copyright (c) 2000, 2016, 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> 
mysql> 
mysql> 
mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
mysql> update mysql.user set authentication_string=password('root') where user='root';
ERROR 1820 (HY000): Unknown error 1820
mysql> 
mysql> 
mysql> 
mysql> use testdb
ERROR 1820 (HY000): Unknown error 1820
mysql> conn testdb
    -> ^C


--修改参数
[root@node1 etc]# vi /etc/my.cnf
validate_password = OFF
---从其mysql
[root@node1 ~]# /etc/rc.d/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@node1 ~]# 


mysql> use mysql
ERROR 1820 (HY000): Unknown error 1820
mysql> 
mysql> 
mysql> 
mysql> use testdb
ERROR 1820 (HY000): Unknown error 1820
mysql> select host,user,password from user ;
ERROR 1046 (3D000): 
mysql> 
mysql> 
六、注意需要从新设置账号密码，可以使用简单的密码
SET PASSWORD = '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E';
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> use testdb;
Database changed
mysql> 
---使用新密码登陆数据库
[root@node1 etc]# mysql -u root  -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.11 MySQL Community Server (GPL)


Copyright (c) 2000, 2016, 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> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed
mysql> 


mysql> uninstall plugin validate_password;
Query OK, 0 rows affected (0.01 sec)


mysql> SET PASSWORD = '1234';
Query OK, 0 rows affected (0.01 sec)


mysql> quit
Bye
---再次登陆数据库，正常使用
[root@node1 etc]# mysql -u root  -p 


Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.11 MySQL Community Server (GPL)


Copyright (c) 2000, 2016, 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> 
mysql> 
mysql> 
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> 
mysql>