mysql permissions

[jbielenda]

I cannot access mysql.

I get the following errors:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'jbielend_webmas'@'67.228.161.42' (using password: YES) in /home/jbielend/public_html/Connections/user.php on line 9

Fatal error: Access denied for user 'jbielend_webmas'@'67.228.161.42' (using password: YES) in /home/jbielend/public_html/Connections/user.php on line 9

I have created a user called jbielend_webmas, and I have given that user full access to the jbielend_db.

I have also attempted to add the user in phpadmin, and get the following error:

Error

SQL query:
CREATE user webmas
MySQL said:
#1227 - Access denied; you need the CREATE USER privilege for this operation

any ideas. I have attached a screenshot of the phpadmin page, and it says:

Create new database:

No Privileges

I am logged in as jbielend@localhost.

Here is what my access code looks like:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_admin = "mysql";
$database_admin = "jbielend_db";
$username_admin = "jbielend_webmas";
$password_admin = "password";
$admin = mysql_pconnect($hostname_admin, $username_admin, $password_admin) or trigger_error(mysql_error(),E_USER_ERROR);
?>

The password is correct.

Any ideas why i cannot access mysql?

Thanks
Jason

 

[bugfinder]

Your hostname is "localhost" not mysql
You also dont have permission to create databases except through the wizard