Messages

1

MySQL / Re: phpMyAdmin 'users' or 'priviledges' tab missing

« 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

 

2

MySQL / 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?

3

PHP / Re: How to change phpmyAdmin password

« on: July 21, 2017, 02:42:57 PM »

Can you tell me  more about it, I am trying to do the same