How can I restore the MySQL root user’s full privileges?
来源:互联网 发布:cctv4网络电视 编辑:程序博客网 时间:2024/06/01 15:00
If the GRANT ALL
doesn't work, try:
- Stop
mysqld
and restart it with the--skip-grant-tables
option. - Connect to the
mysqld
server with just:mysql
(i.e. no-p
option, and username may not be required). Issue the following commands in the mysql client:
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
After that, you should be able to run GRANT ALL ON *.* TO 'root'@'localhost';
and have it work.
- How can I restore the MySQL root user’s full privileges?
- How can I remove this user
- How can I disable the User Account Control (UAC) feature on my Windows Vista computer?
- How can I disable/modify the SSH login banner for a given user?
- How to get root privileges?
- How can I install mySQL on CentOS without being root/su?
- How to Add a User and Grant Root Privileges on CentOS 6.5
- How can i change the title?
- mysql create user grant privileges
- How can I access my Wubi root.disk data
- How-To create a MySQL database and set privileges to a user
- How can I extract the SIGHASH flags from the signature?
- How can I change a file's encoding with vim?
- mysql how to fix Access denied for user 'root'@'localhost'
- How do I perform a manual full refresh instead of using the Apply program to do the full refresh?
- How can I display the chevron button for toolbar?
- How can I change the TCP/IP tuning parameters?
- How can I run Perl system commands in the background
- 深度剖析WinPcap之(二)——网络分析与嗅探的基础知识(2)
- PHP V5.3 在 Unicode 方面有何新特性?
- J2ME简单吗?
- Oracle 9i 的安装(图解)
- inline用法(转)
- How can I restore the MySQL root user’s full privileges?
- Ubuntu下安装Anjuta
- 连连看小游戏,两天才调试出来,TNND!
- Visual Studio 2010 下载,安装,激活,序列号,注册码,下载地址(全集) 附Visual Studio 2008
- 关于ComboBox中SetCurSel()函数
- 【日常】关于Eclipse开发基于cxf的web services的基本步骤
- 【AGM】《风色幻想:纷争—luca篇》角色调整版
- 献给30岁之前为前途迷茫彷徨的男人们的忠告
- 互联网网站的反爬虫策略浅析