MySQL 遠程訪問問題
1.sudo vim mysql.conf.d/mysqld.cnf 注掉 #bind-address = 127.0.0.1
2.登陸進入mysql-server:/etc/mysql$ mysql -uroot -p
Enter password:
mysql> use mysql
mysql> update user set Host = '%' where user = 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'lixiul' WITH GRANT OPTION; //授權來自任何機器 可以以用戶名root,密碼lixiul登陸mysql服務器
FLUSH PRIVILEGES; //保存修改
3. service mysql restart //重啟mysql服務
MySQL 中文亂碼問題
1 修改/etc/mysql/my.cnf添加如下內容
[mysqld]
character-set-server=utf8
[mysql.server]
default-character-set=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf82 重啟mysqlservice mysql restart3 進入mysqlmysql> SHOW VARIABLES LIKE 'character_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql>
另外如果你想更好的提升你的編程能力，學好C語言C++編程！彎道超車，快人一步！筆者這里或許可以幫到你~
分享（原始碼、專案實戰視頻、專案筆記，基礎入門教程）
歡迎轉行和學習編程的伙伴，利用更多的資料學習成長比自己琢磨更快哦！
編程學習：
編程學習：
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/271175.html
標籤：其他