Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 15 of 15
  1. #1
    Member
    Join Date
    Nov 2005
    Posts
    26

    Unhappy Unusual problem with MySql

    Dear Sirs,

    I'm having some unusual problem with mysql in my server....

    I can create the database, user, set permissions, etc with no problem via Cpanel, I can see the entire database via PhpMyadmin, but in an php file I'm having some problems...

    Scripts that was running with no problems in another server, has problem in this one, as you can see at:

    http://www.host-it.com.br/whmm/whmcs...p?step=2&pid=3

    Some times there is no error, but nothing happen as you can see at
    http://www.nuish.net/news.php?newsid=1 (here, you should see one article but you can see nothing)

    I think it depend which mysql function or command is running...


    I’m running MySQL - 5.0.21-standard In fedora core 3.
    Anybody know what should be happening?

    Thank you!
    Last edited by Guigows; 07-24-2006 at 06:09 PM.

  2. #2
    Member
    Join Date
    Mar 2006
    Posts
    1,215

    Default

    Looks like your password is not setup correctly in the database. you may want to delete the database user and flush the privelages and recreate it again.

  3. #3
    Member
    Join Date
    Nov 2005
    Posts
    26

    Default

    Quote Originally Posted by jayh38
    Looks like your password is not setup correctly in the database. you may want to delete the database user and flush the privelages and recreate it again.
    I did, but the problem remains...

  4. #4
    Member
    Join Date
    Oct 2005
    Posts
    37

    Default Try this

    Hi,

    This is your error out put

    " Access denied for user 'hostit'@'localhost' (using password: NO) ". It says that password is not used. Please double check your user name and password for the particular database in the php config file. Try username and pass from command line to login.
    Anish T S
    Unix system administrator

  5. #5
    Member
    Join Date
    Nov 2005
    Posts
    26

    Default

    Quote Originally Posted by Anishts
    Hi,

    This is your error out put

    " Access denied for user 'hostit'@'localhost' (using password: NO) ". It says that password is not used. Please double check your user name and password for the particular database in the php config file. Try username and pass from command line to login.

    Username and password are ok... I'd created database, users again, and the problem remains....

  6. #6
    Member
    Join Date
    Apr 2002
    Posts
    86

    Default

    The "(using password: NO)" part tells you that your PHP script isn't sending a password to be checked. I'd check your variables to make sure it's being passed to MySQL during the connection.

    Also, unless MySQL's error syntax has changed recently, 'hostit'@'localhost' should be 'hostit@localhost' in the error. Probably nothing though.

    If you have shell access, try:

    mysql -u usernamehere -p

    It will prompt for a password. That will tell you if those are correct.

  7. #7
    Member
    Join Date
    Nov 2005
    Posts
    26

    Default

    Quote Originally Posted by WebmastTroy
    The "(using password: NO)" part tells you that your PHP script isn't sending a password to be checked. I'd check your variables to make sure it's being passed to MySQL during the connection.

    Also, unless MySQL's error syntax has changed recently, 'hostit'@'localhost' should be 'hostit@localhost' in the error. Probably nothing though.

    If you have shell access, try:

    mysql -u usernamehere -p

    It will prompt for a password. That will tell you if those are correct.

    log ok!! I really don't know what is happenig...

  8. #8
    Member
    Join Date
    Oct 2005
    Posts
    37

    Default

    Hi,

    Have you tried what WebmastTroy said

    from shell

    # mysql -u hostit -p

    and give us the result...


    Anish T S
    Unix system administrator

  9. #9
    cPanel Partner NOC cPanel Partner NOC Badge AndyReed's Avatar
    Join Date
    May 2004
    Location
    Minneapolis, MN
    Posts
    2,223

    Default

    Quote Originally Posted by Guigows
    log ok!! I really don't know what is happenig...
    I could be mistaken, but MySQL v5 doesn't support all Php scripts. Did you have MySQL v5 on the previous server? If yes and the script worked there just fine, then check the log files for any errors. If you can't solve this problem yourself or if nothing here helps, hire a sys admin.
    Andy Reed
    RHCE and CCNA
    ServerTune.com

  10. #10
    Member
    Join Date
    Nov 2005
    Posts
    26

    Default

    Quote Originally Posted by Anishts
    Hi,

    Have you tried what WebmastTroy said

    from shell

    # mysql -u hostit -p

    and give us the result...



    hello!

    the user accout is "hostit" the mysql user is "hostit_whm"
    follow results of both:
    ----------------------------------------------------------------------
    root@host [~]# mysql -u hostit -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 10170 to server version: 5.0.21-standard

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql>
    -----------------------------------------------------------------------
    root@host [~]# mysql -u hostit_whm -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 10172 to server version: 5.0.21-standard

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql>
    -------------------------------------------------------------------------

  11. #11
    Member
    Join Date
    Oct 2005
    Posts
    37

    Default Hi

    This clearly shows that there is no problem with username and password.It seems that the issue is with php script. Can you check the username and password given in config.php or some thing like that in the directory/or in subdirectories that defines database connection. and if you fond please verify the username and password again in the config file.

    Anish T S
    Unix system administrator

  12. #12
    Member
    Join Date
    Nov 2005
    Posts
    26

    Default

    Quote Originally Posted by Anishts
    This clearly shows that there is no problem with username and password.It seems that the issue is with php script. Can you check the username and password given in config.php or some thing like that in the directory/or in subdirectories that defines database connection. and if you fond please verify the username and password again in the config file.

    Everything with config.php are ok, username, passwd... this script works ok in another server...
    This server doesn’t run any script with mysql as you can see another script in this server
    http://www.nuish.net/news.php?newsid=1 you should see an article but you see nothing.

    Thanx

  13. #13
    Member
    Join Date
    Oct 2005
    Posts
    37

    Default Hi

    Seems like you need to get in touch with an system admin...

    Anish T S
    Unix system administrator

  14. #14
    Member
    Join Date
    Nov 2005
    Posts
    26

    Default

    Quote Originally Posted by Anishts
    Seems like you need to get in touch with an system admin...

    My sys admin is sick... do you know someone?

  15. #15
    Member
    Join Date
    Feb 2004
    Location
    Chile
    Posts
    146

    Default

    Maybe is the oldpassword thing.

    You must open the mysql console and run:

    SET PASSWORD FOR `user`@`localhost` oldpassword=('passhere');

    *** YOU MUST CREATE THE USER FIRST***
    Evolution Technology Web Hosting Support.
    MSN: webmaster@scqcc.cl

Similar Threads & Tags
Similar threads

  1. Unusual lockup from attack.
    By DesigningKnight in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 07-05-2009, 11:27 PM
  2. unusual bandwidth usage?
    By nike.stars in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 07-29-2008, 09:02 AM
  3. php cannot send mail - unusual problem - urgent
    By shx in forum cPanel and WHM Discussions
    Replies: 5
    Last Post: 10-25-2006, 12:50 PM
  4. Unusual phpsuexec Problem
    By x86eon in forum cPanel and WHM Discussions
    Replies: 10
    Last Post: 08-25-2006, 06:30 PM
  5. Very Unusual Problem
    By v2webltd in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 10-23-2002, 06:32 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube