MySQLAdmin

[terrencebrown]

If this seems like a simple question, forgive me.

Does a user have enough access right to:

bash-2.04$ mysqladmin --u=user --password=password CREATE database

or

mysql> CREATE DATABASE database

?

Any help is greatly appreciated.

Perhaps I'm not used to not being the admin.

[nsr81]

I don't think you can do it from shell. I tried it and I got access denied error.
ysqladmin: CREATE DATABASE failed; error: 'Access denied for user: 'nsr81@localhost' to database 'database''

But creating a database is generally done through control panel's Advance Menu. You need to create a database and create a user and add the user to the database.

It's much more easier to do it from CPanel than through commandline.

[terrencebrown]

Thanks!

I was just trying to avoid using the cpanel to find the limitations of the shell.

Surely there has to be a way of creating a db in the shell.

[reuben]

Hmm,

I'm not to sure to tell you the truth. I have never tried it through the shell.

[terrencebrown]

Betty in tadesting.