MySQL Database. - Printable Version

MySQL Database. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Database. (/showthread.php?tid=515414)

MySQL Database. - Jaay - 25.05.2014

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.

Re : MySQL Database. - TheDzGhost - 25.05.2014

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

Re: MySQL Database. - Mark_Weston - 25.05.2014

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.

Re: MySQL Database. - Jaay - 26.05.2014

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?

Re : MySQL Database. - TheDzGhost - 26.05.2014

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]

Re: MySQL Database. - Mark_Weston - 26.05.2014

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!