Control Web Panel

WebPanel => MySQL => Topic started by: gkarvindr on July 21, 2017, 02:57:10 PM

Title: phpMyAdmin 'users' or 'priviledges' tab missing
Post by: gkarvindr on July 21, 2017, 02:57:10 PM
 phpMyAdmin - it seems like the 'users' or 'priviledges' tab in the main navigation panel is missing. So I can't add new users to my database. Any idea where to start looking?
Title: Re: phpMyAdmin 'users' or 'priviledges' tab missing
Post by: gkarvindr on July 21, 2017, 03:31:15 PM
Got is resolved

   To change the mysql password for the root user, do the following:

1.  unload mysqld.nlm
2.  at the console, type: mysqld_safe --skip-grant-tables --autoclose
3.  at the server console type mysql

This will bring you to the mysql prompt.  At this prompt type the following: (Where ******** is the new password, NOTE: the single quotes ARE REQUIRED)

mysql> UPDATE mysql.user SET Password=PASSWORD('********') WHERE User='root';
mysql> FLUSH PRIVILEGES;

Flush privileges will make the change take effect immediately.

You can, in MySQL Version 3.22 and above, use the SET PASSWORD statement: (Where ******** is the new password, NOTE: the single quotes ARE REQUIRED)

shell> mysql -u root mysql
mysql> SET PASSWORD FOR root=PASSWORD('********');

Another way to set the password is by using the mysqladmin command: (Where ******** is the new password)

shell> mysqladmin -u root password ********
shell> mysqladmin flush-privileges

 
Title: Re: phpMyAdmin 'users' or 'priviledges' tab missing
Post by: studio4host on July 21, 2017, 06:55:49 PM
you can reset  mysql password for root user by using this command, its faster :)
Code: [Select]
sh /scripts/mysql_pwd_reset