Mysql: What Do I Do First?

I know SQL statements and a little PHP. I want to create an online database and a friend gave me this cd with tutorials on PHP and MySQL development. I'm lost in all these deleting user, setting privileges part. Can anyone make me understand these things better?

Why don't you start by visitng http://www.mysql.com/ and http://php.net/ - if you aren't bothered by a little reading - these sites have plenty of information to get you started.. These two are too vast topics to cover in any post.

Alongwith, you should grab copies of MySQL and PHP (for whatever platform you're running on - Windows or Linux) from those sites and install them on your system. Only then those tutorials will come to good use. Nothing like doing it hands on and testing it out right then. You could do it at the Xisto server as well but that a slow process.. use own own system for testing instead..

All the best

I know SQL statements and a little PHP.  I want to create an online database and a friend gave me this cd with tutorials on PHP and MySQL development.  I'm lost in all these deleting user, setting privileges part.  Can anyone make me understand these things better?

52023[/snapback]

Go to your cPanel and click on "MySQL Databases", here you can easily create, modify and remove users, permissions and databases.

Let's say you want to make a database you will use for testing things, you might call it test. Type in "test" (without the quote-marks) and click on "Create MySQL database". Now you will have a database called leiaah_test (or if your hosting name isn't leiaah, then it will be yourhostingname_test. This happens automatically, so if you type in "leiaah_test", the DB will be called "leiaah_leiaah_test").

Next you make a user. You will use the user (and the password) to connect to the database later on. Type in a username and a password in the name & password fields and click on "Create MySQL user". Just like with the database name, the username (but not the password!) will get "leiaah_" added in front of it.

Great. Now you have a database and a user, now all you have to do it grant permissions. This is so that the database server knows what the user is allowed and not allowed to do. Under " Grant permissions on a MySQL database to a MySQL user" choose the user and the database and make sure "ALL" is selected (later on you might want to change things to specific permissions, but for now ALL will do), and click on "Grant permissions".

All set! You have a database called leiaah_test (or something like that), a user called leiaah_something (and a password).

Hope this helps

thanks guys...