Create A Db Through Phpmyadmin

[cajunman4life]

Hi, in phpMyAdmin, "Create Database" under MySql says "No Privileges". Is that an error? Shouldn't I be able to create a new database? I suppose I could always create the db on my machine at home, and upload it (btw, where are mysql db's stored on the virtual hosting accounts?).

[abinidi]

I don't know why it does that. I had this question last week, so I submitted a question to the help desk. They told me that I have to create databases using the "My SQL Databases" link. Once the database has been created, and users have been added to it, you can administer it in phpMyAdmin.

 

I know, it seems weird. But it worked for me.

 

EDIT: "users" should be singular. You only have to add one user, but you can add more if needed.

Edited May 5, 2005 by abinidi

[TweezerMan]

Hi, in phpMyAdmin, "Create Database" under MySql says "No Privileges". Is that an error? Shouldn't I be able to create a new database? I suppose I could always create the db on my machine at home, and upload it (btw, where are mysql db's stored on the virtual hosting accounts?).

<{POST_SNAPBACK}>

It is not an error. As abinidi noted, you create your databases and add users from the "MySQL Databases" page in CPanel. I presume this is to 1) prevent scripts from automatically creating databases, and 2) make sure that database names and users are properly prefixed with your CPanel username, so each user can properly access their databases (and only their databases).

 

The MySQL databases are stored on the server, but not in a location you can access directly. Uploading a MySQL database to the correct location and having it properly recognized in CPanel and phpMyAdmin would require assitance from the Help Desk (not recommended except in unusual circumstances).

[cajunman4life]

I don't know why it does that. I had this question last week, so I submitted a question to the help desk. They told me that I have to create databases using the "My SQL Databases" link. Once the database has been created, and users have been added to it, you can administer it in phpMyAdmin.

 

I know, it seems weird. But it worked for me.

 

EDIT: "users" should be singular. You only have to add one user, but you can add more if needed.

<{POST_SNAPBACK}>

 

Thanks for your reply! I'll do that.

 

Does anybody know where the MySQL databases are stored in a virtual hosting account? For instance, on my Gentoo server they are located in /var/lib/mysql, perhaps they are in a similar location? Or are they actually stored under your user account?

[cajunman4life]

Hi, in phpMyAdmin, "Create Database" under MySql says "No Privileges". Is that an error? Shouldn't I be able to create a new database? I suppose I could always create the db on my machine at home, and upload it (btw, where are mysql db's stored on the virtual hosting accounts?).

<{POST_SNAPBACK}>

It is not an error. As abinidi noted, you create your databases and add users from the "MySQL Databases" page in CPanel. I presume this is to 1) prevent scripts from automatically creating databases, and 2) make sure that database names and users are properly prefixed with your CPanel username, so each user can properly access their databases (and only their databases).

 

The MySQL databases are stored on the server, but not in a location you can access directly. Uploading a MySQL database to the correct location and having it properly recognized in CPanel and phpMyAdmin would require assitance from the Help Desk (not recommended except in unusual circumstances).

<{POST_SNAPBACK}>

 

Ok, you answered my question. It appears you and I posted at the same time. Thanks for the answer!

[abinidi]

Thanks for your reply! I'll do that.

<{POST_SNAPBACK}>

You're welcome! Glad I could be helpful.

[abinidi]

It is not an error.  As abinidi noted, you create your databases and add users from the "MySQL Databases" page in CPanel.  I presume this is to 1) prevent scripts from automatically creating databases, and 2) make sure that database names and users are properly prefixed with your CPanel username, so each user can properly access their databases (and only their databases).

<{POST_SNAPBACK}>

This makes sense. Thanks for that explanation.

The MySQL databases are stored on the server, but not in a location you can access directly.  Uploading a MySQL database to the correct location and having it properly recognized in CPanel and phpMyAdmin would require assitance from the Help Desk (not recommended except in unusual circumstances).

<{POST_SNAPBACK}>

So does hitting the database count against bandwith? I'm not really sure how this functions, so mabye this isn't really an issue of bandwith.

[TweezerMan]

So does hitting the database count against bandwith? I'm not really sure how this functions, so mabye this isn't really an issue of bandwith.

<{POST_SNAPBACK}>

I don't believe that just hitting the MySQL database itself counts against bandwidth, as that occurs on the server internally. Imagine you have a script that dumps your MySQL database and displays the dump in your browser window. The actual MySQL query that retrieves the data would not count against your bandwidth, but the bandwidth used to send that data to your browser *does* count. Hopefully that makes sense...

[timm]

It is not an error.  As abinidi noted, you create your databases and add users from the "MySQL Databases" page in CPanel.  I presume this is to 1) prevent scripts from automatically creating databases, and 2) make sure that database names and users are properly prefixed with your CPanel username, so each user can properly access their databases (and only their databases).

 

The MySQL databases are stored on the server, but not in a location you can access directly.  Uploading a MySQL database to the correct location and having it properly recognized in CPanel and phpMyAdmin would require assitance from the Help Desk (not recommended except in unusual circumstances).

<{POST_SNAPBACK}>

 

I tried this and it did not work for me.

I am a newbie to this.

In cpanel I clicked on mysql databases. I had a database and one user there already and it would not work earlier so I deleted all databases and users. then created database then created user then gave user access all privilages to database. it says this x user has access (all privaligies (SP? ) so ok it is working so far. I click on phpmyadmin and here it always says *no privaligies !! what am I doing wrong? I tried to create a table etc and it does not save.

 

also do I need to create a user?

 

thanks in adavance

[TweezerMan]

Welcome to the forums, timm!

 

There's three steps to setting up a MySQL database:

 

1) Add (create) database

2) Add (create) user

3) Add user to database (grant user privileges to access database)

 

Once you've completed these 3 steps, you should be able to access your database in phpMyAdmin.

 

You may want to look at the TCH movie tutorial on setting up MySQL accounts, illustrating how to perform the above three steps.

 

Hope this helps...

[TCH-Thomas]

Welcome to the forum, timm.

[TCH-Bruce]

Welcome to the forums, timm

[TCH-Don]

Welcome to the forum, timm