创建MySQL账户
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了创建MySQL账户，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2859字，纯文字阅读大概需要5分钟。
内容图文
!/usr/bin/env python3
# -*- coding: utf-8 -*-
#----------------------------------------------------------#
# Date : xxxx-xx-xx #
# Author : Created by zhouwanchun. #
# Wechat : loveoracle11g #
# Function: This scripts function is ... #
# Version : 1.1 #
#----------------------------------------------------------#
# 导入模块
import os
import subprocess
import mysql.connector
import myloginpath
# Linux终端清屏
os.system(‘clear‘)
# 注释信息
print("""\033[1;36m
############################################################
# Date : 2020-05-22 #
# Author : Created by zhouwanchun. #
# Wechat : loveoracle11g #
# Function: This scripts function is ... #
# Version : v1.1 #
############################################################
\033[0m""")
# 连接数据库账号
conn_user = ‘dba‘
print("""\033[1;35m
创建管理账号，请输入 : manager
创建开发账号，请输入 : dev
\033[0m""")
choices = input("请输入你要创建的账号类型 : ").strip()
def create_mysql_user():
user = input("请设置user : ").strip()
host = input("请设置host : ").strip()
password = input("请设置密码 : ").strip()
create_user = "create user " + "‘" + user + "‘" + "@" + "‘" + host + "‘" + " identified by " + "‘" + password + "‘;"
if choices == ‘manager‘:
grant_user = "grant all privileges on *.* to " + "‘" + user + "‘" + "@" + "‘" + host + "‘" + " with grant option;"
else:
grant_user = "grant SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER on *.* to " + "‘" + user + "‘" + "@" + "‘" + host + "‘" + " with grant option;"
show_grants = "show grants for " + "‘" + user + "‘" + "@" + "‘" + host + "‘;"
subprocess.run([‘/usr/local/mysql/bin/mysql --login-path=‘ + conn_user + ‘ -e ‘ + ‘"‘ + create_user + ‘"‘], shell=True)
subprocess.run([‘/usr/local/mysql/bin/mysql --login-path=‘ + conn_user + ‘ -e ‘ + ‘"‘ + grant_user + ‘"‘], shell=True)
subprocess.run([‘/usr/local/mysql/bin/mysqladmin --login-path=‘ + conn_user + ‘ flush-privileges‘], shell=True)
subprocess.run([‘/usr/local/mysql/bin/mysql --login-path=‘ + conn_user + ‘ -e ‘ + ‘"‘ + show_grants + ‘"‘], shell=True)
return
if choices == ‘manager‘:
create_mysql_user()
elif choices == ‘dev‘:
create_mysql_user()
else:
print("\033[1;31m你输入有误！\033[0m")
创建MySQL账户
标签：hat cut 类型 创建 开发 usr system dev log
本文系统来源：https://www.cnblogs.com/zhouwanchun/p/13269503.html
内容总结
以上是互联网集市为您收集整理的创建MySQL账户全部内容，希望文章能够帮你解决创建MySQL账户所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】