mysql5.6linux安装

《mysql5.6linux安装》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、Mysql安装过程（linux：2.6.18-194.el5，Mysql：）1、安装[root@RAC2mysql]#rpm-ivhMySQL-server-5.6.12-2.rhel5.x86_64.rpmPreparing...###########################################[100%]1:MySQL-server###########################################[100%][root@RAC2mysql]#rpm-ivhMySQL-clie

2、nt-5.6.12-2.rhel5.x86_64.rpmPreparing...###########################################[100%]1:MySQL-client###########################################[100%]2、安装完查看默认3306端口没有开[root@RAC2mysql]#netstat-natActiveInternetconnections(serversandestablished)ProtoRecv-QSend-

3、QLocalAddressForeignAddressStatetcp000.0.0.0:8330.0.0.0:*LISTENtcp000.0.0.0:1110.0.0.0:*LISTENtcp00127.0.0.1:6310.0.0.0:*LISTENtcp00127.0.0.1:250.0.0.0:*LISTENtcp00:::22:::*LISTENtcp00::ffff:192.168.72.5:22::ffff:192.168.72.1:63851ESTABLISHEDtcp00::ffff:192.168.

4、72.5:22::ffff:192.168.72.1:62929ESTABLISHED3、将mysql启动[root@RAC2init.d]#servicemysqlstartStartingMySQL..[确定]4、再次确认端口是打开的[root@RAC2init.d]#netstat-natActiveInternetconnections(serversandestablished)ProtoRecv-QSend-QLocalAddressForeignAddressStatetcp000.0.0.0:8330.

5、0.0.0:*LISTENtcp000.0.0.0:1110.0.0.0:*LISTENtcp00127.0.0.1:6310.0.0.0:*LISTENtcp00127.0.0.1:250.0.0.0:*LISTENtcp00:::3306:::*LISTENtcp00:::22:::*LISTENtcp00::ffff:192.168.72.5:22::ffff:192.168.72.1:63851ESTABLISHEDtcp00::ffff:192.168.72.5:22::ffff:192.168.72.1:6

6、2929ESTABLISHED5、连接mysql[root@RAC2bin]#mysql-urootERROR1045(28000):Accessdeniedforuser'root'@'localhost'(usingpassword:NO)在网上查资料，可以这样来解决：[root@RAC2bin]#/etc/init.d/mysqlstopShuttingdownMySQL..[确定][root@RAC2bin]#mysqld_safe--user=mysql--skip-grant-tables--skip-ne

7、tworking&[1]6025[root@RAC2bin]#13071619:00:36mysqld_safeLoggingto'/var/lib/mysql/RAC2.err'.13071619:00:36mysqld_safeStartingmysqlddaemonwithdatabasesfrom/var/lib/mysql[root@RAC2bin]#mysql-urootmysqlReadingtableinformationforcompletionoftableandcolumnnamesYoucant

8、urnoffthisfeaturetogetaquickerstartupwith-AWelcometotheMySQLmonitor.Commandsendwith;org.YourMySQLconnectionidis2Serverversion:5.6.12MySQLCommunityServer(GPL)Copyrigh