Php And Mysql

[jgingras]

Hi! Im new to the php and mysql world and am trying to figure out the mysql_connect. In cPanel --> Manage mySQL, I have my database setup,

 

named = username_dbname

my user has all privileges for that database.

 

I dont know what im missing. Here is my code. and the error that I get.

 

code:

 

$oconn=mysql_connect ("localhost", "username_", "******") or die ("I cannot connect to the database because: " . mysql_error());

mysql_select_db ("username_dbname");

 

 

error:

mysql_connect(): Access denied for user: 'username_@localhost' (Using password: YES) in /home/username/public_html/admin/loginpost.php on line 5

 

For the error and code and changed my username to "username" and put *s instead of my password. I only have two php pages on my whole site, login.php which has a form to pass a username and password to connect to the site, (tblUsers in my db.) and this page. Am I missing another page? Am I missing other settings?

 

Your help is much appreciated,

Thanks,

-Jacques

[GroovyFish]

Hi Jacques and welcome to the forum!

 

It's hard to tell for sure from your example, but you should be using:

 

cpanelusername_dbusername for the username

cpanelusername_dbname for the database name

 

Is that what you are using?

[TCH-Don]

Welcome to the forums Jacques

 

 

The normal steps to use a database is

in MySql

create a database with a name like nuke

create a user for the database like cmsuser

with a password of xyz123

 

then add cmsuser to the nuke database

 

The connect string should be in the form of

 

$dbh=mysql_connect ("localhost", "cpanelname_cmsuser", "xyz123") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("cpanelname_nuke");

 

 

The most common error is forgetting to add the user to the database in MySql

and will result in an error much like yours.

[TCH-Andy]

HI Jacques

 

Welcome to the family

[jgingras]

Don and GroovyFish, thanks for that help. I was just using cpanelname_ as my username, so I added a new user and added it to the db and it worked great!

 

Thanks for all your help.

 

Glad to be on-board!

 

-Jacques

[TCH-Don]

Glad you have working.

 

let us know if you need more help

[TCH-Bruce]

Welcome to the forums Jacques

[TweezerMan]

Welcome to the forums, Jacques!

[TCH-Thomas]

Welcome to the forum, Jacques.

[stevevan]

Welcome to the forums!

[TheMovieman]

Rather than starting a new post, I found this one and thought I'd ask it here.

 

I haven't used MySQL Administrator in a while so I have forgotten the password. Since I am starting over with a database, I made a new one and added a user (for which I know the password) and gave it all privileges.

 

However, when starting the MySQL Administrator, I type in the username cpanelname_username and the password (both I know are correct) but I get this error:

 

MySQL Error Number: 1045

Access Denied to User:

'cpanelname_username@<stuff> us.da.qwest.net' (Using Password: YES)

 

Now, the Server Host is correct and the port is 3306 (don't know if that makes a difference...).

 

I had this working months ago and encountered a problem like this but cannot remember how I fixed it.

 

BTW, I also created a new user and tried it there, but got the same error.

[TCH-Bruce]

Are you also accessing the database as cpanelname_database?

[TheMovieman]

I'm a little slow today, what do you mean?

Edited July 25, 2005 by TheMovieman

[TweezerMan]

It sounds like you need to go into CPanel / MySQL Databases and add your computer's IP address under "Access Hosts" (near the bottom of the page) to grant your PC permission to access the MySQL server.

[TheMovieman]

Haha, what'd you? It did work! Thanks David!

Edited July 26, 2005 by TheMovieman