Mysql: What Do I Do First?

leiaah

Feb 19 2005, 04:49 PM

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?

miCRoSCoPiC^eaRthLinG

Feb 19 2005, 05:58 PM

Why don't you start by visitng http://www.mysql.com and http://www.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 Trap17 server as well but that a slow process.. use own own system for testing instead..

All the best

bjrn

Feb 19 2005, 11:26 PM

QUOTE(leiaah @ Feb 19 2005, 05:49 PM)

I'm assuming you want to do it here on Trap17.

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

leiaah

Feb 20 2005, 02:53 PM

thanks guys...

Similar Topics

Keywords : mysql

Learning Mysql - pls guide (3)
hello out there, i have already looked through on this tutorial forum.. and still can find any
topics which related to MySql basic.. i wanna learn about how to create MySql table and its
concept!! just basic.. i've no knowledge on MySql before nor any other database server
software.. but i do have littol konwledge on programming,scripting,html basic in concept.. pls dun
gave me so many links so as i can be blur for none about how to get start!! /laugh.gif'
border='0' style='vertical-align:middle' alt='laugh.gif' /> i can thou find from Googles sear...

Ipb Mysql Probelm - (1)

Mysql... - and its limits? (11)

I haven't been able to try out any mysql databases, but is more than one really required?
I'm looking at most hosts and most offer unlimited mysql databases. Shouldn't one database
be enough? I would guess one can hold several kinds of information in sub-databases, maybe?...

Installing Apache,mysql And Php In Windows - Good text for beginners (4)

Here it is the text i have found in CODE http://www.jevontech.com/ , and i'm posting
this text because i remember the dificults i had when i wanted to do this right... Installing
Apache , MySQL and PHP under Windows Introduction While many webservers run Linux, Unix or BSD most
personals computers run on Windows. So it would be quite comfortable if web designers and
developers could develop on their home computer.So in this E-book we will focus on configuring your
computer to use Apache, MySQL and PHP, so you can work on your home computer. Step 1: Ins...

All Database Query - MySql, Sql Server, All Database Talk! (4)

Dear All Friends! I have create this topic for everyone who have some problem with query
analyses. You could post all your problem with database. We all would have and find a solution for
you. Now let me start my small problem. This i have fixed but i just think of the best way. I
got 3 tables: table_users ( user_id ,user_name,user_pass,user_group) table_group ( group_id
,group_name) table_usersingroup ( ursingro_id , user_id , group_id ) I need output like this:
username | password | group test1 | ***** | (group1,gro...

Mysql - Any help?.. (7)

Alright, well. Let's face it, I can understand PHP, but MySQL seems like... Chinese to Japanese.
Korean to Vietnamese. Totally different, but looks the same to some. Anyway, I was wondering.. Are
there any understandable tutorials out there that involve php? WebMonkey confuses me (@_@) I'll
be eternally in your debt. Edit: It seems I can understand MySQL fairly okay, it's phpMyAdmin
that confuses me. /laugh.gif' border='0' style='vertical-align:middle' alt='laugh.gif' /> -
Zenchi Discalimer: I'm a liar....

Looking for mysql

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE