1。 改表法。可能是你的帐号不允许从远程登陆,只能在localhost。这个时候只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"
Sql代码 复制代码
1. mysql -u root -pvmwaremysql>use mysql;
2. mysql>update user set host = '%' where user = 'root';
3. mysql>select host, user from user;
2. 授权法。例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
Sql代码 复制代码
1. GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH
GRANT OPTION;
2.FLUSH PRIVILEGES;
如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器,并使用mypassword作为密码
Sql代码 复制代码
1. GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY
2. 'mypassword' WITH GRANT OPTION;
3. FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY
'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器的dk数据库,并使用mypassword作为密码
Sql代码 复制代码
1. GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY
2. 'mypassword' WITH GRANT OPTION;
3. FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY
'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
注意授权后必须FLUSH PRIVILEGES;否则无法立即生效。
另外一种方法.
在安装mysql的机器上运行:
1、d:\mysql\bin\>mysql -h localhost -u root
//这样应该可以进入MySQL服务器
2、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION
//赋予任何主机访问数据的权限
3、mysql>FLUSH PRIVILEGES
//修改生效
4、mysql>EXIT
//退出MySQL服务器
这样就可以在其它任何的主机上以root身份登录啦!
分享到:
相关推荐
mysql 赋给用户权限 grant all privileges on.docx
grant all privileges on *.* to ‘jirauser’@'%’ identified by ‘jira’ with grant option; grant all privileges on *.* to ‘jirauser’@'localhost’ identified by ‘jira’with grant option; flush ...
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION; user:myuser pwd:mypassword 从192.168.1.3连接到mysql服务器 GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’...
mysql yum install mysql mysql-server mysql-devel 完成后,用 /etc/init.d/mysqld start 启动mysql ... GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
转到GraphQL API样板 ...postgres= # GRANT ALL PRIVILEGES ON DATABASE go TO go; 在db.go配置数据库 // ConnectDB : connecting DB func ConnectDB () ( * DB , error ) { db , err := gorm . Open
1.安装deb文件 ...2.修改/etc/my.cnfdatadir = /data01...create user root identified byyoupasswordmysg1>root'@'% identified by '123456' with grant option,mysq1>grant all privileges on *.* to flush privileges;
mysql5.7arm64.zip mysql5.7在麒麟arm64架构下的deb安装包 1.安装deb文件 ...mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option; mysql> flush privileges;
grant all privileges on *.* to root@"%" identified by "."; 视图权限:The user specified as a definer ('root'@'%') does not exist https://blog.csdn.net/u010999809/article/details/87806126
影视大全爬虫代码+后台搭建。...grant all privileges on movie_database.* to 'www'@'%' identified by 'www'; 此命令作用是创建MySQL的用户名和口令,均为www,并赋予操作test数据库的所有权限。 创建movie表。
# dnf clean all # dnf install zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-sql-...mysql> grant all privileges on zabbix.* to zabbix@localhost; mysql> SET GLOBAL log_bin_trust_function_
设置mysql数据库远程连接: Windows系统 1、 停止mysql的服务。...GRANT ALL PRIVILEGES ON *.* TO root@’%’ IDENTIFIED BY ‘hkgt123’ WITH GRANT OPTION; 7、 提交:commit; 8、 刷新权限:flush privileges;
h5手游[星辰变]手工架设服务端+数据库+架设流程 架设流程: 星辰变h5手机游戏 手工架设服务端+...GRANT ALL PRIVILEGES ON *.* TO ‘root’@” IDENTIFIED BY ‘V1ZoT2JVMUVTWG89’ WITH GRANT OPTION; FLUSH PR
mysql>mysql -u root –p 2)允许本地 IP 访问 localhost, 127.0.0.1 mysql> insert into mysql.user(Host,User,Password) values...mysql>grant all privileges on `zhouzdb`.* to 'zhouz'@'%' identified by '1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION; flush privileges; 防火墙开启3306端口 # vi /etc/sysconfig/iptables 添加如下内容: -A INPUT -m state --state NEW -m ...
- 使用`GRANT ALL PRIVILEGES`语句授予用户所有权限,即允许用户对所有数据库和表进行操作; - 使用`GRANT`语句授予用户特定权限,例如SELECT和INSERT操作,指定数据库、表、用户名和主机名; - 使用`REVOKE`语句...
hive介绍和hive环境搭建。。一、 安装mysql 1.... 授权:grant all privileges on *.* to 'hive'@'%' with grant option 9. 重启一下这个mysql服务。 10. 使用hive用户创建数据库并修改连接信息。
GRANT ALL PRIVILEGES ON *.* TO 'Ubuntu'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 删除授权 revoke insert,update,delete,select ON *.* from 'Ubuntu'@'%' IDENTIFIED BY '123456'; 腾讯云出现权限不够...
主要介绍了MySQL如何使用授权命令grant,文中示例代码非常详细,帮助大家更好的理解和学习,感兴趣的朋友可以了解下
privileges on *.* to 'amanda'@'localhost' identified by '123456'; grant all privileges on *.* to 'amanda'@'127.0.0.1' identified by '123456'; grant all privileges on *.* to 'amanda'@'::1' ident
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '......' WITH GRANT OPTION;(或者是:grant all privileges on *.* to root@'%' identified by "你的新密码";) FLUSH PRIVILEGES; 10、设置开机...