数据库开发记录 - Githubissues

You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'. The recommended solution is to drop this anonymous user (this is usually a good thing to do anyways). 取消这样的匿名用户？如何去掉？不如试着新建一个用户名

CREATE USER nbr IDENTIFIED BY 'password';

重建后依然不行，再观察发现自己命令输错，输错多了用户名就无效了，回到root用户名创建数据库就可以。需要在root用户名下，即管理员权限中对新的用户名进行授权，新的用户名才可以对数据库进行操作

根据一下资料，重新熟悉用户名添加删除，创建数据库，授权，更新的操作命令： Mysql 创建、删除用户 - fly1988happy - 博客园

nibirongdeMacBook-Pro:TagaDay NBR-hugh$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15

mysql> drop user nbr;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER nbr IDENTIFIED BY '1234';
Query OK, 0 rows affected (0.01 sec)

mysql> exit
Bye
nibirongdeMacBook-Pro:TagaDay NBR-hugh$ mysql -u nbr -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16

mysql> exit
Bye

nibirongdeMacBook-Pro:TagaDay NBR-hugh$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17

mysql> grant all privileges on testDB.* to nbr@localhost identified by '1234';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

NBR-hugh commented 7 years ago

3.python脚本连接mysql数据库

再运行python脚本测试，成功建立数据库链接，执行sql操作。

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb

class MySQLdb_operation(object):

    def __init__(self):
        pass

    def Creat_table(self):
        # 建立数据库连接
        db = MySQLdb.connect(host="localhost",user="nbr",passwd="1234",db="testDB")
        # 使用cursor()方法获取操作游标 
        cursor = db.cursor()
        # 使用execute方法执行SQL语句
        cursor.execute("SELECT VERSION()")
        # 使用 fetchone() 方法获取一条数据库。
        data = cursor.fetchone()
        print "Database version : %s " % data
        # 关闭数据库连接
        db.close()

if __name__ == '__main__':

    Op = MySQLdb_operation()
    Op.Creat_table()

nibirongdeMacBook-Pro:TagaDay NBR-hugh$ python demo.py
Database version : 5.7.17

Lesley19 / TagaDay

数据库开发记录 #2

1.安装MySQLdb模块

2.MySQL使用

keng1

keng2

3.python脚本连接mysql数据库