LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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-14-2010, 04:35 PM   #1
rodriguez
LQ Newbie
 
Registered: Jan 2010
Posts: 5

Rep: Reputation: 0
Can't login to phpMyAdmin


I've just installed phpmyadmin on my bioLinux. When the logo screen shows http://localhost/phpmyadmin, and I try to log in it appears: #1045 Cannot log in to the MySQL server.
I've tried all posibilities. I install and reinstall it with the Synaptic Package manager, with and without password (using 'root' as username).

Could anyone help me? Thanks
 
Old 07-14-2010, 04:48 PM   #2
bizshop
LQ Newbie
 
Registered: Dec 2004
Posts: 14
Blog Entries: 1

Rep: Reputation: 0
Can't Log In to phpMyAdmin

3 questions:

1. Did you install MySQL? phpMyAdmin is just a front end for that.
2. When you installed MySQL, what username and password did you set up as admin?
3. Can you log in from the command line to your MySQL database?

Answering those 3 should help you solve the problem - if not, post back and I'll try to help more.
 
Old 07-14-2010, 04:49 PM   #3
vsurlan
Member
 
Registered: Jun 2004
Location: Zagreb, Croatia
Distribution: Debian Lenny
Posts: 49

Rep: Reputation: 15
Is MySQL installed?
Can you login to MySQL from the command line?
Are MySQL and phpMyAdmin on the same machine?
 
Old 07-14-2010, 05:12 PM   #4
whk
Member
 
Registered: Jun 2005
Posts: 200

Rep: Reputation: 35
If the solutions from the gurus above don't work.

]# mysql -uroot
>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your password here');
>flush privileges;
\q
then
]# mysql -uroot -p

or
]# mysqladmin -u root password "my new password"


You should have checked(peruse) MySQL out before hand.

Last edited by whk; 07-15-2010 at 11:22 AM.
 
Old 07-14-2010, 05:14 PM   #5
rodriguez
LQ Newbie
 
Registered: Jan 2010
Posts: 5

Original Poster
Rep: Reputation: 0
I think that MySQL is properly installed, in the terminal:

mysql -h localhost -U root -p xxxxxxx
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
....
 
Old 07-15-2010, 12:34 AM   #6
bizshop
LQ Newbie
 
Registered: Dec 2004
Posts: 14
Blog Entries: 1

Rep: Reputation: 0
Can't Log In to phpMyAdmin

I believe that should be mysql -u root -p xxxx

When you do that, your prompt should change to a mysql> prompt that tells you are actually in. Type status at that prompt to confirm all is ok

-U is not the same as -u , but perhaps you typed the post wrong.

Can you open a database or browse a table from the command line? That will also tell you if mysql is working ok.

I'd also recommend giving mysqladmin a go to tell you more about what is going on.

By default, there is no password for root in mysql, so unless you've set it try logging in at the phpMyAdmin login screen with root user and blank for password.

info on setting mysql root password
 
Old 07-15-2010, 12:51 AM   #7
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Nagpur, India
Distribution: Cent OS 5/6, Ubuntu Server 10.04
Posts: 4,627

Rep: Reputation: Disabled
And is the MySQL server running?
 
Old 07-15-2010, 09:43 AM   #8
rodriguez
LQ Newbie
 
Registered: Jan 2010
Posts: 5

Original Poster
Rep: Reputation: 0
Thanks a lot for the replies!

I just set up a new password

$ mysqladmin -u root password NEWPASSWORD

and login phpmyadmin with 'root' and my newpassword. I donīt know why doing this before, with root as user name and blank for password didnīt work.

Thank you.
 
Old 09-14-2011, 06:54 PM   #9
magicg
LQ Newbie
 
Registered: Jun 2011
Posts: 2

Rep: Reputation: Disabled
Smile Troubleshooting Phpmyadmin

Here is a Troubleshooting:

http://install-climber.blogspot.com/...onding-or.html
 
Old 09-15-2011, 12:39 AM   #10
svetlyoh
LQ Newbie
 
Registered: Sep 2011
Posts: 2

Rep: Reputation: Disabled
Thumbs up This worked for me as well.

I installed mysql using synaptic manager. Didn't have to enter a root password.
The command
mysqladmin -u root password NEWPASSWORD

worked. I was able to login into PhpMyAdmin immediately.
 
Old 04-10-2012, 03:04 AM   #11
hanimaj
LQ Newbie
 
Registered: Apr 2012
Posts: 1

Rep: Reputation: Disabled
Smile

I have the same problem,thanks to whk his solution worked!
 
Old 04-11-2012, 12:39 AM   #12
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Nagpur, India
Distribution: Cent OS 5/6, Ubuntu Server 10.04
Posts: 4,627

Rep: Reputation: Disabled
phpMyAdmin does not allow blank passwords by default. You can change the behavior in config.inc.php but setting up a password for root is secure option. And if you can setup a new user which will have database specific privileges, that would be more secure.
 
  


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
phpmyadmin remote login M_C Linux - Server 3 04-28-2009 07:40 AM
can't login to phpmyadmin candyman123 Linux - Software 2 05-27-2006 08:18 PM
What is the defult phpmyadmin login badgerbox76 Linux - Newbie 2 01-08-2006 02:36 PM
phpmyadmin: can not login quarry_06 Linux - Software 1 04-27-2005 10:37 AM
phpmyadmin can't login vladimir@ares Linux - Software 2 12-31-2004 03:00 AM


All times are GMT -5. The time now is 03:47 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration