Creating MySQL Databases from the command line - permission denied

[patwa]

OK, in my bid to learn more and stay on my Unix high, I decided to install my new CMS purely through SSH.

I found a tutorial on using mysql through the command line.

mysql -u username -p - OK.

CREATE DATABASE e107; - Error 1004 - Access denied for username username at localhost to database e107.

What am I doing wrong? I tried using the \g to send the command as well, as defined in the MySQL help page, but no go.

Thanks.

H.

[gooshy]

Hi,Just from looking at the error message the user you are logged in as does not have permission to create databases. Try and create one through cpanel, which runs under a different user. Then create a user to access the database through cpanel grant the relevant permissions and log into the database with your new user at the commans line.

[Sam]

patwa,

I dont think you can create mysql database's in jailshell

[patwa]

Originally Posted by _Sam_

patwa,

I dont think you can create mysql database's in jailshell

Ah that would make sense then if it was a 'global' ban on database creation. Seeing as the user I was logge din as was myself, it couldn't have been a user specific issue. Anyone able to advise what I can do with jailshell as regards mysql, I already know about importing and exporting databases? It's so much easier than using the cpanel gui.

[charlesgan]

CREATE DATABASE `dbname_here` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `db_username`;

you need to set the user name that used to create the db

[patwa]

Thanks, will try this.

Cheers.

H.