[Jaay]

Hello, I am looking for anybody to help me or give me a link on how I can setup a MySQL database for my SAMP Server?

Thanks.

[TheDzGhost]

Where you wanna stup it : in your computer ? In a VPS? In a Gameserver?

[Mark_Weston]

You can it via SSH (complicated) or phpmyadmin.

Assuming you're using a VPS/Linux OS with -centos.

Do the following: yum install php-*, yum install phpmyadmin

vpsip/your up/phpmyadmin


and clicks users, create user. follow the boxes, Check these two: "Create database with same name and grant all privileges
Grant all privileges on wildcard name (username\_%)"


press go.


and click on the table on the left side whatever you named your username to be.

and you make your shit over there. That is a long lesson, too hard to explain. So you will just figure it out, or you can use ******.com.

[Jaay]

Right up to now I have installed XAMPP and ran Apache and MySQL from it (I am hosting the server from my PC as it is just for test purposes)
I have a .sql file ready but need to import it so it will run the script?

[TheDzGhost]

Hello,
If your are hosting the server in your PC , you need to install WampServer (To host a SQL date-base in your localhost)
download link : http://www.wampserver.com/
How to use?
[ame]http://www.youtube.com/watch?v=W1i44VmrIWY[/ame]

[Mark_Weston]

I hate wamp, use xampp.

Basilica run the apache server, and the mysql server.

Go to 127.0.0.1/phpmyadmin

1) Click on "Users" on the top
2) Click "Add User" on the bottom
3) Fill out the boxes.

Код:

Username: Whatever.
Host: I usually use Local, but most of the time all hosts.
Password: Hit generate and save the pass that it shows you.

4) Check mark these two "Create database with same name and grant all privileges
Grant all privileges on wildcard name (username\_%)"

and hit "Go" don't touch the global privileges.

5) Click on the database on the left it will be the same name that you used for your username.
6) Hit the "import" button on the top menu.
7) Upload your SQL dump
You're done!