Step 4/mySQL Database

[Exigo]

Hi, can anyone help me to set up an mySQL database? i dont understand a shit

[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

[Exigo]

No, im seting up a own local server, whit Xampp

[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:

Code: Select all

mysql -u root -p

Create the database:

Code: Select all

create database cmsms;

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:

Code: Select all

mysqladmin -u root -p reload

You can also use PHPMyAdmin to create the database.

Regards,
D

[Exigo]

Explane more, im a n00b on this shit,,