How to create a database in a proper computer?

[OnlineCheater]

Hey everyone,

I was just wondering if it was possible for me to create a database ( MySQL) in my own computer which is working with windows 10.

So then I would use it to save the data related to MTA scripts from my home server...

Could you just tell me how can I do this please, I've been checking this: https://wiki.multitheftauto.com/wiki/DbConnect

So what do I have to add as Required Arguments? I mean for example:

dbtype = "mysql"

dbname = "name of the db"

dbhost = "should i enter my home IP adress? where do i get this host"

dbuser = "username? where can i find the username? which one? i don't understand this"

dbpw = "password? same way, i don't understand where can i find this password"

servconnec = dbConnect( dbtype, dbname,dbhost,dbuser,dbpw )

That's all I need to know, I hope it's possible to do and if there's a tutorial anywhere, please inform me about it.

Thanks in advance!

[KariiiM]

Yes it's possible, to host MySQL in local, use one of some programes which they supports PHP and MySQL so you can control your data.

I suggest you to use XAMPP it contains about all these features.

About how to open a connection to MySQL database, you've to use dbConnect function

the usage of it should be like that,

local connection = dbConnect("mysql", "dbname= myDbName; host= 127.0.0.1; port= 3306","root","","share=1") 

[OnlineCheater]

Alright thanks, I'm currently trying to use XAMPP's MySQL so when I click on the MySQL Admin button of the Control panel, http://localhost/phpmyadmin/ opens but there's nothing, just a white screen. There should be a content but there's nothing.

How can I fix this?

[KariiiM]

Alright thanks, I'm currently trying to use XAMPP's MySQL so when I click on the MySQL Admin button of the Control panel, http://localhost/phpmyadmin/ opens but there's nothing, just a white screen. There should be a content but there's nothing.

How can I fix this?

If I am not wrong XAMPP doesn't works if skype is running, check XAMPP's logs to get where's the issue exists.

Edit: next time try to post a screenshot

[stevensalvaro]

Xampp , are you just start MySQL and Apache2 ?

[stevensalvaro]

I can help you if you need some help just contact me on facebook @[email protected]

[sheenidgs]

Make sure your Apache and MySQL is running. Open your XAMPP Control Panel

[KariiiM]

And make sure Skype is not running.

[OnlineCheater]

It's ok guys don't worry I found another way to use phpMyAdmin, it's EasyPHP

[stevensalvaro]

solved ? idk if it's work because mta must call mysql to get database table

[OnlineCheater]

solved ? idk if it's work because mta must call mysql to get database table

I successfully connected a script to the db table created on phpMyAdmin

It worked!

[stevensalvaro]

nice