ããlinuxè¿ç¨ç»å½mysqlçæ¹æ³
è¿ç¨è¿æ¥ä¸Linuxç³»ç»ï¼ç¡®ä¿Linuxç³»ç»å·²ç»å®è£ ä¸äºMySQLæ°æ®åºãç»éæ°æ®åºãmysql -uroot -pï¼å¯ç ï¼ã
å建ç¨æ·ç¨æ¥è¿ç¨è¿æ¥
GRANT ALL PRIVILEGES ON *.* TO 'itoffice'@'%' IDENTIFIED BY 'itoffice' WITH GRANT OPTION;
ï¼ç¬¬ä¸ä¸ªitoffice表示ç¨æ·åï¼%表示ææççµèé½å¯ä»¥è¿æ¥ï¼ä¹å¯ä»¥è®¾ç½®æ个ipå°åè¿è¡è¿æ¥ï¼ç¬¬äºä¸ªitoffice表示å¯ç ï¼ã
æ§è¡ flush privileges;å½ä»¤ç«å³çæ
æ¥è¯¢æ°æ®åºçç¨æ·ï¼çå°å¦ä¸å 容表示å建æ°ç¨æ·æåäºï¼
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
使ç¨exitå½ä»¤éåºMySQL
ç¶åæå¼vim /etc/mysql/my.cnf
å°bind-address = 127.0.0.1
设置æbind-address = 0.0.0.0ï¼è®¾å¤å°åï¼
éæ°å¯å¨ï¼å½ä»¤å¦ä¸ï¼ï¼
/etc/init.d/mysql stop
/etc/init.d/mysql start
æ¥ç端å£å·show global variables like 'port';
设置navicatè¿æ¥ã
ç¹å»è¿æ¥æµè¯çå°å¦ä¸å 容表示æåã