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 11-05-2009, 07:11 PM   #1
gr33d
Member
 
Registered: Dec 2008
Posts: 41

Rep: Reputation: 15
mysql root password apostrophe prohibits phpmyadmin login


following howtoforge.com tutorial for centos 5.4 with ispconfig 3

i set my mysql root password to a value with an apostrophe:
mysqladmin -u root password 123'456
>mysqladmin -h server.example.com -u root password 123'456
ctrl + c (couldnt figure out how to quit)

installed phpmyadmin. surfed to http://server1.example.com/phpmyadmin
prompted for password--doesnt work
tried root, mysql and leaving username blank too

cant find correct syntax to change password from command line. do i need to somehow escape the apostrophe???

thanks in advance!
 
Old 11-06-2009, 09:42 AM   #2
Guttorm
Senior Member
 
Registered: Dec 2003
Location: Trondheim, Norway
Distribution: Debian and Ubuntu
Posts: 1,261

Rep: Reputation: 297Reputation: 297Reputation: 297
Hi

I don't think you actually set any root password. When you try the command:

mysqladmin -u root password 123'456

The shell see the ' and it will wait until it finds another ' before it will do anything. And since you hit ctrl + c you stopped it.

I think you should be able to login with phpmyadmin using root as username and no password. But you really should set a password as soon as possible. If you want ' in the password, you can use it inside ".

mysqladmin -u root password "123'456"
 
Old 11-06-2009, 10:55 AM   #3
gr33d
Member
 
Registered: Dec 2008
Posts: 41

Original Poster
Rep: Reputation: 15
Blank password did not work. I found a solution that I will post when I get back to my box. It involved stopping mysqld and editing something to allow a passwordless login to mysql.

Thank you for the double-quote syntax though!
 
Old 11-06-2009, 10:58 AM   #4
gr33d
Member
 
Registered: Dec 2008
Posts: 41

Original Poster
Rep: Reputation: 15
Blank password did not work. I found a solution that I will post when I get back to my box. It involved stopping mysqld and editing something to allow a passwordless login to mysql.

Thank you for the double-quote syntax though!
 
Old 11-09-2009, 10:31 AM   #5
gr33d
Member
 
Registered: Dec 2008
Posts: 41

Original Poster
Rep: Reputation: 15
these are directions to follow to reset the password:

http://www.debian-administration.org/articles/442

thanks for the help along the way!
 
  


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
mysql: still can't login after root password reset andredude Linux - Software 4 12-19-2014 07:30 PM
[phpMYAdmin] Problem ! Help. I''ve deleted root user in MYSQL combilli Linux - Software 1 12-07-2006 02:30 PM
Big problem changed root password for mysql can't login pls comment johnnydangerous Linux - Software 5 07-08-2005 02:22 AM
MYSQL paranoia security prohibits PHP to use database ? Dark Carnival Debian 1 01-08-2005 11:33 AM
phpMyAdmin login rejection as root ??? cdrobsonjr Linux - Software 2 12-01-2004 10:12 PM


All times are GMT -5. The time now is 06:28 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration