Lost MySQL Root User, Create Root User skip-grant-tables#

  • Login via SSH
  • Open /etc/my.cnf
  • add the following under the mysqld group
skip-grant-tables
  • Restart MySQL and now you can login as any user with full permissions
  • Go to mysql database and add a root user with permissions manually, set all priv fields to Y

For MySQL 4

INSERT INTO user VALUES('localhost','root',PASSWORD('PASSWORD'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
  • Remove the skip-grant-tables
  • Restart MySQL and now you can login with your root user

Back to MySQL

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-6) was last changed on 24-May-2017 15:30 by Hyve Support
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 4619

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1