mySQL created & right password yet connection failed?

[jago25_98]

Created mySQL database and right password yet connection failed.

The help is only mentioning creating the database and user/pass. Do I need to add some sort of user to the mysql group?

root ~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 36
Server version: 5.0.51a-24+lenny4 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database zencart;
Query OK, 1 row affected (0.01 sec)

mysql> quit
Bye

Then

Connection to Database failed
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Using the same user & pass of course.

[stevesh]

Many hosts prepend the control panel user name to the database name on shared servers, so if your control panel user name is jago25, and your database name is store, Zencart will need jago25_store as the DB name in the configure files.

[jago25_98]

Many hosts prepend the control panel user name to the database name on shared servers, so if your control panel user name is jago25, and your database name is store, Zencart will need jago25_store as the DB name in the configure files.

I tend to prefer things on the command line but I'm happy to install a control panel (cpanel perhaps) if you think it would help this root VPS which I've installed from scratch

-j

[RodG]

Do I need to add some sort of user to the mysql group?

No, but you do need to create a zencart user/password and give them access priviliges to the zencart database that you created.

It *is* possible to use the root user/password to obtain the databse access, but this is very bad practice and needs to be avoided at all costs (those on a shared server don't/won't have root access anyway, but I understand that you have a VPS).

I can appreciate wishing to use the command line (I'm a great fan myself), but in all honesty, when it comes to MySQL I suggest you install phpMyAdmin and use this excellent tool for *all* of your database administration. You won't reget it.

Cheers
Rod