SA-MP Forums Archive
How to start a mysql server from computer - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: How to start a mysql server from computer (/showthread.php?tid=626737)



How to start a mysql server from computer - AndreiWow - 19.01.2017

I want to make a mysql gamemode from 0 on mysql but how can I run in from my computer, I don't have any database


Re: How to start a mysql server from computer - Rongvaldyr - 19.01.2017

Maybe this tutorial can be helpful for you; https://sampforum.blast.hk/showthread.php?tid=574714


Re: How to start a mysql server from computer - kelvinis - 19.01.2017

You need to find a way to get PHPMYADMIN so you can make your own database.
Then you just need to script or get a script(wich runs on MYSQL) and change the defines to your PHPMYADMIN connect password, username, host and database


Re: How to start a mysql server from computer - Luicy. - 19.01.2017

First off, no you don't need PHPMyAdmin, that's just a web side based database manager.
So well..

1.) Download http://dev.mysql.com/downloads/file/?id=467605
2.) Run and install it.
3.) While installing, choose port 3306, TCP/IP, and Firewall port.
4.) Choose a hard password, not 123, a HARD!
5.) Add an user with a rememberable username such as "root", all hosts, and the same password.
6.) Finish everything and then launch the server.

To launch the server..
http://dev.mysql.com/doc/refman/5.7/...rst-start.html


Re: How to start a mysql server from computer - AndreiWow - 19.01.2017

Quote:
Originally Posted by Luicy.
Посмотреть сообщение
First off, no you don't need PHPMyAdmin, that's just a web side based database manager.
So well..

1.) Download http://dev.mysql.com/downloads/file/?id=467605
2.) Run and install it.
3.) While installing, choose port 3306, TCP/IP, and Firewall port.
4.) Choose a hard password, not 123, a HARD!
5.) Add an user with a rememberable username such as "root", all hosts, and the same password.
6.) Finish everything and then launch the server.

To launch the server..
http://dev.mysql.com/doc/refman/5.7/...rst-start.html
Thanks, rep+


Re: How to start a mysql server from computer - 4D1L - 19.01.2017

To be honest, it's just much simpler using XAMPP.


Re: How to start a mysql server from computer - Luicy. - 19.01.2017

Quote:
Originally Posted by 4D1L
Посмотреть сообщение
To be honest, it's just much simpler using XAMPP.
But then you get lots of other shit which isn't even needed.


Re: How to start a mysql server from computer - AndreiWow - 19.01.2017

Quote:
Originally Posted by Luicy.
Посмотреть сообщение
First off, no you don't need PHPMyAdmin, that's just a web side based database manager.
So well..

1.) Download http://dev.mysql.com/downloads/file/?id=467605
2.) Run and install it.
3.) While installing, choose port 3306, TCP/IP, and Firewall port.
4.) Choose a hard password, not 123, a HARD!
5.) Add an user with a rememberable username such as "root", all hosts, and the same password.
6.) Finish everything and then launch the server.

To launch the server..
http://dev.mysql.com/doc/refman/5.7/...rst-start.html
Where can I find the files that will save?


Re: How to start a mysql server from computer - princejeet1510 - 20.01.2017

You will find them in default directory where all other default databases are stored....
PS:I would recommend to use XAMPP as that isn't really hard to use once they come in handy....


Re: How to start a mysql server from computer - Luicy. - 20.01.2017

Quote:
Originally Posted by AndreiWow
Посмотреть сообщение
Where can I find the files that will save?
Download a MySQL Database Manager such as phpMyAdmin, or Navicat. I suggest Navicat strongly.
https://www.navicat.com/download/navicat-premium
Connect to the host, username, and pass and then you got access.