phpMyAdmin 'users' or 'priviledges' tab missing

 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?

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

 

you can reset  mysql password for root user by using this command, its faster

Code: [Select]

sh /scripts/mysql_pwd_reset