#1 (permalink)  
Old 07-24-2006, 04:42 PM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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 05:09 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 07-24-2006, 07:28 PM
Registered User
 
Join Date: Mar 2006
Posts: 1,215
jayh38 is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 07-24-2006, 10:22 PM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 07-25-2006, 07:28 AM
Registered User
 
Join Date: Oct 2005
Posts: 37
Anishts is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 07-26-2006, 09:03 AM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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....
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 07-26-2006, 10:12 AM
Registered User
 
Join Date: Apr 2002
Posts: 86
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 07-29-2006, 08:34 AM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 07-29-2006, 09:36 AM
Registered User
 
Join Date: Oct 2005
Posts: 37
Anishts is on a distinguished road
Hi,

Have you tried what WebmastTroy said

from shell

# mysql -u hostit -p

and give us the result...


__________________
Anish T S
Unix system administrator
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 07-29-2006, 09:45 AM
AndyReed's Avatar
cPanel Partner NOC
cPanel Partner NOC Badge
 
Join Date: May 2004
Location: Minneapolis, MN
Posts: 2,212
AndyReed is on a distinguished road
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
ServerTune.com
Dedicated server hosting, Colocation Services, Server Management, and cPanel Licenses
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 07-29-2006, 01:50 PM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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>
-------------------------------------------------------------------------
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #11 (permalink)  
Old 08-01-2006, 11:20 AM
Registered User
 
Join Date: Oct 2005
Posts: 37
Anishts is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12 (permalink)  
Old 08-01-2006, 05:36 PM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #13 (permalink)  
Old 08-02-2006, 03:16 AM
Registered User
 
Join Date: Oct 2005
Posts: 37
Anishts is on a distinguished road
Hi

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

__________________
Anish T S
Unix system administrator
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #14 (permalink)  
Old 08-02-2006, 08:31 PM
Registered User
 
Join Date: Nov 2005
Posts: 26
Guigows is on a distinguished road
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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #15 (permalink)  
Old 08-02-2006, 08:35 PM
Registered User
 
Join Date: Feb 2004
Location: Chile
Posts: 145
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***
__________________
Evolution Technology Web Hosting Support.
MSN: webmaster@scqcc.cl
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 01:15 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
© cPanel Inc