Access Denied for user.

[Duxie]

Having a few problems with creating a new table in MySql. I'm using the tutorial from "PHP fast&easy web development" by Julie C. Meloni
I keep pouring over the script and am starting to think that it not the script but the
manner in which MySql has been set up.
I've created a user and given them a password via the web hosts Control Panel.

This script bounces back with:
Access denied for user: 'Gustav@localhost' (Using password: YES)
Originally the Pasword contained a numerical character and my web host claimed that MySql had trouble dealing with this. (Sound like BS to me)

<?
$db_name = "testDB";
$connection = @mysql_connect("localhost", "Gustav", "ChangedForSecurity")
or die(mysql_error());
$db = @mysql_select_db($db_name, $connection) 
or die(mysql_error());
$sql = "CREATE TABLE $_POST[table_name] (";
for ($i = 0; $i < count ($_POST[field_name]); $i++) {
	$sql .= $_POST[field_name] [$i]." ".$_POST[field_type] [$i];
	if ($_POST[field_length] [$i] != "") {
		$sql .= " (".$_POST[field_length] [$i]."),";
	} else {
			$sql .= ",";
	}
}
$sql = substr($sql, 0, -1);
$sql .= ")";
$result = mysql_query($sql,$connection) or die(mysql_error());
if ($result) {
	$msg = "<P>".$_POST[table_name]." has been created!</P>";
	}
?>

Any ideas on what's going on?
Am I missing some typo or do I know more about this than my webhost?
😕

[craigh]

after you create the user, did you 'reload MySQL' ? I don't know what that means, but I know you have to do it. If you are using phpMyAdmin, there is a link to do that.

[Duxie]

I don't see any link on the "Control Panel" for that.
Wouldn't that be on the server host side?

[KoshNaranek]

are you using linux or windows?

on linux:

a)
cd /etc/init.d
mysql restart
b)
killall -HUP mysql
or c)
login to mysql:
mysql -u [username] -p

enter:
flush privileges;

the anser from mysql will look like this:
Query OK, 0 rows affected (0.17 sec)

on windows:
stop and start the mysql-Server via the Icon in the tray
or download the mysql-control-center from www.mysql.com
connect to the sever - right-click on Server-Administration.
Select flush -> privileges

[Duxie]

um.
Way over my head on this one.
MySQL is running on the Webhost. Doesn't that prevent me from configing the .ini?
(I'm totally a newbie on this, so please excuse me if I'm way wrong)

[KoshNaranek]

.ini?:rolleyes: really "wrong way" 🙂

Ok... here we go...

You've created a table? How?
You've created a user? How?
When you create a user, you MUST flush the privileges to "activate" this new user...

Installing phpMyAdmin on the webhost will help 😉
makes mysql much easier

[Duxie]

I added both the table and the user via, what the web host calls, Cpanel 5 - Site Control Panel. Yikes... ok found the "Flush Knob"
Flushed and got:
Database nitoichi_testDB - table userauth running on localhost
Error
SQL-query :
FLUSH TABLE userauth
MySQL said:
Access denied for user: 'nitoichi@localhost' (Using password: YES)"

Posting the previous issue to my web host resulted in:
"Make sure you use the database name and the username added to the database name with the account username. So if your user name would be cat and the database user dog, your database username in your script would be: cat_dog
Also the user has the cat_ prefix and your password for the database has not. "

I've changed the code to read:

$connection = @mysql_connect("localhost", "nitoichi_Gustav", "ChangedForSecurity")

as recommended, and lo and behold... I'm still unable to connect.

So... back to flushing....

[KoshNaranek]

Ok... another try.

replace the "localhost" in the connection-string with the IP of the mySQL-Server. Maybe this will help.

"localhost" only works, if webserver and mysql-server do run on a single machine.