3回答

sqlercn

2020-02-22

执行一下，下面这条语句，把结果贴出来。
select user, host, plugin from mysql. user where user='root'

0

0

weixin_慕慕3319289

提问者

2020-02-22

这个问题已经解决了，运行命令后又出现其他问题；下面是代码，再下面就是报错信息， 我再网上找了方法， 输入网上提供的代码输入进去 也是报错，

---这是代码--

[root@MySql ~]# cat connect_mysql.py 

#!/usr/bin/env python

#encoding=utf-8

import pymysql

db_host='localhost'

db_user='root'

db_pass='123456'

db_database='mysql'

db_port=3306

if __name__ == '__main__':

        conn = pymysql.connect(host=db_host,port=db_port,user=db_user,passwd=db_pass,db=db_database)

        sqlstr="""

        select user, host from user

        """

cursor=conn.cursor()

cursor.execute(sqlstr)

result=cursor.fetchall()

for i in result:

        print ("user:%s host:%s"%(i[0],i[1]))

conn.close()

-----运行报错---

[root@MySql ~]# python connect_mysql.py 

Traceback (most recent call last):

  File "connect_mysql.py", line 11, in <module>

    conn = pymysql.connect(host=db_host,port=db_port,user=db_user,passwd=db_pass,db=db_database)

  File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in Connect

    return Connection(*args, **kwargs)

  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 325, in __init__

    self.connect()

  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 598, in connect

    self._get_server_information()

  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 975, in _get_server_information

    packet = self._read_packet()

  File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet

    packet.check_error()

  File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error

    err.raise_mysql_exception(self._data)

  File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception

    raise errorclass(errno, errval)

pymysql.err.InternalError: (1130, u"Host '127.0.0.1' is not allowed to connect to this MySQL server")

[root@MySql ~]# 

-------------网上说要修改允许外部连接数据库，也是报错--------

mysql> grant privileges on *.* to 'root'@'%' identified by 123456 with grant option;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 123456 with grant option' at line 1

mysql> 

老师帮忙看看

0

0

sqlercn

2020-02-22

贴一下你的全部代码看看

0

1

weixin_慕慕3319289

老师只能输入1200字以内，我贴到上面到回答了

2020-02-22

共1条回复