Page 1 of 1
Step 4/mySQL Database
Posted: Thu Feb 15, 2007 11:18 pm
by Exigo
Hi, can anyone help me to set up an mySQL database? i dont understand a shit
Re: Step 4/mySQL Database
Posted: Thu Feb 15, 2007 11:45 pm
by Dee
Are you setting up a local server? Normally you would get MySQL database info (username, password, databasename) from your provider. If no hostname is provided localhost (default) should be the correct setting.
Regards,
D
Re: Step 4/mySQL Database
Posted: Fri Feb 16, 2007 7:06 am
by Exigo
No, im seting up a own local server, whit Xampp
Re: Step 4/mySQL Database
Posted: Fri Feb 16, 2007 8:44 am
by Dee
XAMPP installs and configures the MySQL server automatically.
Install it
as a service so it gets started automatically when your computer is started.
To create the database:
Start mysql:
Create the database:
Give permissions to a database user (substitute username and password with your own values):
Code: Select all
GRANT INSERT,SELECT,UPDATE,DELETE,CREATE,DROP ON cmsms.* TO username@localhost IDENTIFIED BY 'password';
Reload the MySQL server:
You can also use PHPMyAdmin to create the database.
Regards,
D
Re: Step 4/mySQL Database
Posted: Fri Feb 16, 2007 2:55 pm
by Exigo
Explane more, im a n00b on this shit,,
