MySQL增加访问ip
MySQL增加访问ip
当使用Python的pymysql访问时,如下
import pymysql db=pymysql.connect("ip","root","passwd","database-name") cursor = db.cursor() cursor.execute("SELECT VERSION()") data = cursor.fetchone() print("Database version : %s " % data) db.close()
会报错
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1130, "10.197.193.23' is not allowed to connect to this MariaDB server")
因为centos里面的mysql默认只能本机访问(localhost),需要进入mysql数据(或者maiadb),添加如下指令,来开通所有IP访问
mysql>GRANT
ALL
PRIVILEGES
ON
*.*
TO
'root'
@
'%'
IDENTIFIED
BY
'123456'
WITH
GRANT
OPTION
;
mysql>flush
privileges
;
下面一种是开通个别开别,例如
mysql>GRANT ALL ON *.* to root@'10.60.160.%' IDENTIFIED BY '123465'; FLUSH PRIVILEGES;
mysql>flush
privileges
;