Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 07-18-2009, 01:00 PM   #1
Registered: Jul 2009
Posts: 52

Rep: Reputation: 15
Change the password for phpMyAdmin on Ubuntu


How do I change the root password for phpMyAdmin on Ubuntu?

Thank you!
Old 07-18-2009, 02:31 PM   #2
Registered: Nov 2005
Location: UK
Distribution: archlinux
Posts: 90

Rep: Reputation: 19
Does this help?
Old 07-19-2009, 07:07 AM   #3
Registered: Aug 2005
Location: Malaysia - KULMY / CNXTH
Distribution: Slackware, Fedora, FreeBSD, Sun O/S 5.10, CentOS
Posts: 780
Blog Entries: 6

Rep: Reputation: 75
is that phpmyadmin root login is for root MySQL database user

in this case you can change root name to any name instead of root
w/o change any privileges for root

after that root login no longer exist, about what will happen to your application eg, forum etc etc.

i sure there none of your database user use root to connect

if it happen you can simply revert back. and about security nobody know
what is root user except you the only one

follow this step

root login to mysql
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
go to mysql db
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
replace root user from user root to user dbaroot
or what ever you named it
mysql> update user set user="dbaroot" where user="root";
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
exit then now try login back
# mysql -u dbaroot -p
Enter password:
then test with your phpmyadmin,



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Change Password of Domain User on Ubuntu Box darknight1726 Linux - Newbie 2 06-11-2008 03:38 AM
phpmyadmin root cannot change privileges blizunt7 Linux - Software 3 03-31-2008 08:03 PM
Get/Change the username & password in a CUSTOM Ubuntu LiveCD tuxhats Ubuntu 0 10-18-2007 09:32 PM
How can I change e-mail password(or linux account password) with php in website?? yusuf Programming 1 05-28-2004 09:39 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:04 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration