MySQL5.6_Linux安装

1、mysql 安装过程（linux ：2.6.18-194.el5，mysql：）1、安装rootrac2 mysql# rpm -ivh mysql-server-5.6.12-2.rhel5.x86_64.rpm preparing. # 100% 1:mysql-server # 100% rootrac2 mysql# rpm -ivh mysql-client-5.6.12-2.rhel5.x86_64.rpm preparing. # 100% 1:mysql-client # 100% 2、安装完查看默认3306 端口没有开rootrac2 mysql# netstat -nat

2、active internet connections (servers and established) proto recv-q send-q local address foreign address state tcp 0 0 0.0.0.0:833 0.0.0.0:* listen tcp 0 0 0.0.0.0:111 0.0.0.0:* listen tcp 0 0 127.0.0.1:631 0.0.0.0:* listen tcp 0 0 127.0.0.1:25 0.0.0.0:* listen tcp 0 0 :22 :* listen tcp 0 0 :ffff:192

3、.168.72.5:22 :ffff:192.168.72.1:63851 established tcp 0 0 :ffff:192.168.72.5:22 :ffff:192.168.72.1:62929 established 3、将 mysql 启动rootrac2 init.d# service mysql start starting mysql.确定 4、再次确认端口是打开的rootrac2 init.d# netstat -nat active internet connections (servers and established) proto recv-q send-q

4、local address foreign address state tcp 0 0 0.0.0.0:833 0.0.0.0:* listen tcp 0 0 0.0.0.0:111 0.0.0.0:* listen tcp 0 0 127.0.0.1:631 0.0.0.0:* listen tcp 0 0 127.0.0.1:25 0.0.0.0:* listen tcp 0 0 :3306 :* listen tcp 0 0 :22 :* listen tcp 0 0 :ffff:192.168.72.5:22 :ffff:192.168.72.1:63851 established

5、tcp 0 0 :ffff:192.168.72.5:22 :ffff:192.168.72.1:62929 established 5、连接 mysql rootrac2 bin# mysql -u root error 1045 (28000): access denied for user rootlocalhost (using password: no) 在网上查资料，可以这样来解决：rootrac2 bin# /etc/init.d/mysql stop shutting down mysql.确定 rootrac2 bin# mysqld_safe -user=mysql -sk

6、ip-grant-tables -skip-networking & 1 6025 rootrac2 bin# 130716 19:00:36 mysqld_safe logging to /var/lib/mysql/rac2.err. 130716 19:00:36 mysqld_safe starting mysqld daemon with databases from /var/lib/mysql rootrac2 bin# mysql -u root mysql reading table information for completion of table and co

7、lumn 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.6.12 mysql community server (gpl) copyright (c) 2000, 2013, oracle and/or its affiliates. all rights reserved. oracle is a

8、 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 | | tes

9、t | +-+ 4 rows in set (0.00 sec) mysql use mysql; database changed mysql show tables; +-+ | tables_in_mysql | +-+ | columns_priv | | db | | event | | func | | general_log | | help_category | | help_keyword | | help_relation | | help_topic | | innodb_index_stats | | innodb_table_stats | | ndb_binlog_

10、index | | plugin | | proc | | procs_priv | | proxies_priv | | servers | | slave_master_info | | slave_relay_log_info | | slave_worker_info | | slow_log | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +-+ 28

11、rows in set (0.00 sec) mysql desc user; +-+-+-+-+-+-+ | field | type | null | key | default | extra | +-+-+-+-+-+-+ | host | char(60) | no | pri | | | | user | char(16) | no | pri | | | | password | char(41) | no | | | | | select_priv | enum(n,y) | no | | n | | | insert_priv | enum(n,y) | no | | n |

12、 | | update_priv | enum(n,y) | no | | n | | | delete_priv | enum(n,y) | no | | n | | | create_priv | enum(n,y) | no | | n | | | drop_priv | enum(n,y) | no | | n | | | reload_priv | enum(n,y) | no | | n | | | shutdown_priv | enum(n,y) | no | | n | | | process_priv | enum(n,y) | no | | n | | | file_pr

13、iv | enum(n,y) | no | | n | | | grant_priv | enum(n,y) | no | | n | | | references_priv | enum(n,y) | no | | n | | | index_priv | enum(n,y) | no | | n | | | alter_priv | enum(n,y) | no | | n | | | show_db_priv | enum(n,y) | no | | n | | | super_priv | enum(n,y) | no | | n | | | create_tmp_table_priv

14、 | enum(n,y) | no | | n | | | lock_tables_priv | enum(n,y) | no | | n | | | execute_priv | enum(n,y) | no | | n | | | repl_slave_priv | enum(n,y) | no | | n | | | repl_client_priv | enum(n,y) | no | | n | | | create_view_priv | enum(n,y) | no | | n | | | show_view_priv | enum(n,y) | no | | n | | | c

15、reate_routine_priv | enum(n,y) | no | | n | | | alter_routine_priv | enum(n,y) | no | | n | | | create_user_priv | enum(n,y) | no | | n | | | event_priv | enum(n,y) | no | | n | | | trigger_priv | enum(n,y) | no | | n | | | create_tablespace_priv | enum(n,y) | no | | n | | | ssl_type | enum(,any,x50

16、9,specified) | no | | | | | ssl_cipher | blob | no | | null | | | x509_issuer | blob | no | | null | | | x509_subject | blob | no | | null | | | max_questions | int(11) unsigned | no | | 0 | | | max_updates | int(11) unsigned | no | | 0 | | | max_connections | int(11) unsigned | no | | 0 | | | max_u

17、ser_connections | int(11) unsigned | no | | 0 | | | plugin | char(64) | yes | | | | | authentication_string | text | yes | | null | | | password_expired | enum(n,y) | no | | n | | +-+-+-+-+-+-+ 43 rows in set (0.00 sec) mysql select hosr,user,password from user; error 1054 (42s22): unknown column ho

18、sr in field list mysql select host,user,password from user; +-+-+-+ | host | user | password | +-+-+-+ | localhost | root | *34f5f8a5c7f9ea100fb15f7fcf1bc31271c3d43c | | rac2 | root | *34f5f8a5c7f9ea100fb15f7fcf1bc31271c3d43c | | 127.0.0.1 | root | *34f5f8a5c7f9ea100fb15f7fcf1bc31271c3d43c | | :1 |

19、root | *34f5f8a5c7f9ea100fb15f7fcf1bc31271c3d43c | +-+-+-+ 4 rows in set (0.00 sec) mysql update user set password=password(root123) where user=root and host=localhost; query ok, 1 row affected (0.00 sec) rows matched: 1 changed: 1 warnings: 0 mysql commit - ; query ok, 0 rows affected (0.00 sec) 执行

20、下面这一句，是因为上面使表处于：the mysql server is running with the -skip-grant-tables option ，如果不执行下面这句，即使连上数据库也执行不了操作。mysql flush privileges; query ok, 0 rows affected (0.00 sec) mysql quit bye rootrac2 bin# /etc/init.d/mysql restart shutting down mysql.130716 19:03:34 mysqld_safe mysqld from pid file /var/lib/mysql/rac2.pid ended 确定 starting mysql.确定 1+ done mysqld_safe -user=mysql -skip-grant-tables -skip-networking rootrac2 bin# mysql -u root -p enter password: welcome to the mysql monitor. commands end with ; or g. your mysql connection id is 1 server version: 5.6.12 cop