LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


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

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


Hello!

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

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

Rep: Reputation: 19
Does this help? http://www.theadminzone.com/forums/s...ad.php?t=16357
 
Old 07-19-2009, 07:07 AM   #3
routers
Member
 
Registered: Aug 2005
Location: Malaysia - KULMY / CNXTH
Distribution: Slackware, Fedora, FreeBSD, Sun O/S 5.10, CentOS
Posts: 787
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
Code:
# 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
Code:
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
Code:
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
Code:
# mysql -u dbaroot -p
Enter password:
then test with your phpmyadmin,

end-
 
  


Reply


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:51 PM.

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