Unusual problem with MySql

[Guigows]

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!

[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.

[Guigows]

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...

[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.

[Guigows]

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....

[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.

[Guigows]

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...

[Anishts]

Hi,

Have you tried what WebmastTroy said

from shell

# mysql -u hostit -p

and give us the result...

[AndyReed]

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.

[Guigows]

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>
-------------------------------------------------------------------------

[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.

[Guigows]

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

[Anishts]

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

[Guigows]

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?

[VirtuaLira]

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***