Forums

×

Warning

JUser: :_load: Unable to load user with ID: 20288
Medium
Offline
Resolved
0 votes
I am really confused, I turned on MySQL for the first time and set the password using the ClearOS web page. Then click on the "Go". So then it kick up a login and this is where I have a problem. I tried to use root and the password I set and it did not work... So I went back to the ClearOS page and changed the password, this seemed to work, but I failed to login again. So I thought maybe it never took so just login with root and no password....nope. So I went back and tried to change the password again and I put the wrong old password in just to see if it would take, it came back telling me I had the wrong old password, so it is working, just not for me..... Any ideas?
Wednesday, July 28 2010, 07:09 AM
Share this post:
Responses (8)
  • Accepted Answer

    Thursday, July 29 2010, 11:28 PM - #Permalink
    Resolved
    0 votes
    I even tried numbers and it did not like it. Really surprising.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, July 29 2010, 10:33 PM - #Permalink
    Resolved
    0 votes
    That's one I knew :)

    back on topic, it is good to know that there are special character issues with MySQL,

    Feature request to add code to the GUI to warn about it!!
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, July 29 2010, 07:45 PM - #Permalink
    Resolved
    0 votes
    Very good! Did you just know or is Google your friend?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, July 29 2010, 05:05 PM - #Permalink
    Resolved
    0 votes
    seoulhawk wrote:
    Now extra credit what does "In like Flint" mean?


    The original quote is "In like Flynn" and refers to Errol Flynn. In like Flint was a Bond movie spoof from the 60's.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, July 28 2010, 10:56 PM - #Permalink
    Resolved
    0 votes
    SOLVED! My problem was I used a strong password that included !@#$ and it did not like it. I dumbed it down and I was in like Flint!

    Now extra credit what does "In like Flint" mean?

    Thanks! :laugh:
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, July 28 2010, 01:45 PM - #Permalink
    Resolved
    0 votes

    Resetting the password for root for MySQL will break any applications that use this account. For this reason and other security reasons, it is best to set up applications to use a separate account for database manipulation


    I was drawing attention to this warning... so if he had set up an application - the implications of changing the root password...
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, July 28 2010, 01:26 PM - #Permalink
    Resolved
    0 votes
    Hes has stated he is changing the password on the built in GUI page. If that is not affecting the root user account for MySQL, then what is that page for?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, July 28 2010, 07:32 AM - #Permalink
    Resolved
    0 votes
    This might help... note the warning re. root

    http://www.clearfoundation.com/docs/howtos/forgot_mysql_password
    The reply is currently minimized Show
Your Reply