MYSQL数据库远程连接与授权DISCUZ中文乱码

远程连接之前，如果有杀毒软件或者防火墙，要在服务器上把discuz 默认3306端口放开

 

 

//给gdgs用户权限授权给128.21.6.141，如果是所有用户用%代替

授权语句

grant select,lock tables on ultrax.* to gdgs@'128.21.6.141' identified by'gdgs';

授权所有权限

--grant all privileges on ultrax.* to gdgs@'128.21.6.141' identified by'gdgs' with grant option;

FLUSH   PRIVILEGES; 

 

直接进入xampp/mysql/bin目录打开mysql.exe执行授权语句

报错空用户无法访问ultrax表

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'ultrax'

 

//所以先用root用户登录

命令行cmd

进入到 对应的mysql bin 目录下

 

依次输入：d:

cd xampp

cd mysql

cd bin

 

//如果没有密码则后面的-p可以删掉

然后用root用户登录输入：mysql -u root  -p xx 

 

再输入授权语句

 

 

 

中文乱码： 打开my.ini文件

 

在[mysql]添加default-character-set=gbk

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

default-character-set=gbk  (添加的)

 

 

在[mysqld]添加character-set-server=gbk

port= 3306

socket = "D:/xampp/mysql/mysql.sock"

basedir = "D:/xampp/mysql" 

tmpdir = "D:/xampp/tmp" 

datadir = "D:/xampp/mysql/data"

pid_file = "mysql.pid"

# enable-named-pipe

key_buffer = 16M

max_allowed_packet = 1M

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

log_error = "mysql_error.log"

 

character-set-server=gbk (添加的)