Author Topic: phpMyAdmin 'users' or 'priviledges' tab missing  (Read 482 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
phpMyAdmin 'users' or 'priviledges' tab missing
« 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?

Offline
*
Re: phpMyAdmin 'users' or 'priviledges' tab missing
« Reply #1 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

 

Offline
*
Re: phpMyAdmin 'users' or 'priviledges' tab missing
« Reply #2 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
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.