《Mysql應(yīng)用Linux服務(wù)器中MySQL遠(yuǎn)程連接的開啟方法》要點(diǎn)：
本文介紹了Mysql應(yīng)用Linux服務(wù)器中MySQL遠(yuǎn)程連接的開啟方法，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。

MYSQL數(shù)據(jù)庫前言

MYSQL數(shù)據(jù)庫學(xué)習(xí)MySQL重新整理以前非MK的記載

MYSQL數(shù)據(jù)庫描述

MYSQL數(shù)據(jù)庫沒有開啟的話連接數(shù)據(jù)庫報(bào)錯(cuò)：2003-can't connect to MYSQL

MYSQL數(shù)據(jù)庫方法/步驟

MYSQL數(shù)據(jù)庫?第一步

MYSQL數(shù)據(jù)庫遠(yuǎn)程連接上Linux系統(tǒng),確保Linux系統(tǒng)已經(jīng)安裝上了MySQL數(shù)據(jù)庫.登陸數(shù)據(jù)庫.

MYSQL數(shù)據(jù)庫mysql -u$user -p $pwd

MYSQL數(shù)據(jù)庫?第二步

MYSQL數(shù)據(jù)庫創(chuàng)建用戶用來遠(yuǎn)程連接

MYSQL數(shù)據(jù)庫GRANT ALL PRIVILEGES ON *.* TO '$username'@'%' IDENTIFIED BY '$password' WITH GRANT OPTION;

MYSQL數(shù)據(jù)庫$username表示用戶名,%表示所有的電腦都可以連接,也可以設(shè)置某個(gè)ip地址運(yùn)行連接,$password表示密碼

MYSQL數(shù)據(jù)庫?第三步

MYSQL數(shù)據(jù)庫執(zhí)行 flush privileges;命令立即生效

MYSQL數(shù)據(jù)庫FLUSH PRIVILEGES;

MYSQL數(shù)據(jù)庫?第四步

MYSQL數(shù)據(jù)庫查詢數(shù)據(jù)庫的用戶

MYSQL數(shù)據(jù)庫SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

MYSQL數(shù)據(jù)庫?第五步

MYSQL數(shù)據(jù)庫然后打開vim /etc/mysql/my.cnf

MYSQL數(shù)據(jù)庫將bind-address = 127.0.0.1

MYSQL數(shù)據(jù)庫設(shè)置成bind-address = 0.0.0.0(設(shè)備地址)

MYSQL數(shù)據(jù)庫重新啟動(dòng)

MYSQL數(shù)據(jù)庫/etc/init.d/mysql restart

MYSQL數(shù)據(jù)庫?查看MYsql全局的端口( 默認(rèn)是3306 )
#查看端口號(hào)

MYSQL數(shù)據(jù)庫show global variables like 'port';

MYSQL數(shù)據(jù)庫至此已經(jīng)配置完成

轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/3680.html