So it would be like this MysqlConn = New MySqlConnection()ĭim server As String = My.Settings. You need to move MysqlConn = New MySqlConnection() on the first line. MysqlConn.ConnectionString = "server=" & server & " " _ Instead of this code: Dim server As String = My.Settings.DB_Serverĭim username As String = My.Settings.DB_Usernameĭim password As String = My.Settings.DB_Passwordĭim database As String = My.Settings.DB_Database Often, item shop items are also available in the game by farming. Also, P-servers offer an item shop where you can get coins for real money to buy game items, but this is usually much cheaper than the official Metin2 server. This can also be a problem in our code, not just in MySQL alone. While it is on the official Metin2 server only possible to be the best by investing a lot of money, you can belong to the best on private servers for free if you invest enough time. For example, I'm using MySQL Workbench and putting in 'Hostname:10.1.1.7', 'Port:3306', 'Username:root'Īll of the answers here didn't work in my case so I guest this may help other users in the future. You should now be able to remote connect to your database. I really must commend CloudFlare for explaining everything so well and making set up easy, because changing name servers and messing with CNAME DNS records. Mysql>GRANT ALL ON *.* to IDENTIFIED BY 'put-your-password' Remember to change the IP Address, Port, and database name to your settings) mysql -u root -p Now access the MySQL Database on your actual server (say your remote address is 123.123.123.123 at port 3306 as user root and I want to change permissions on database 'dataentry'. For my example, I'll say the actual server is on 10.1.1.7) bind-address (by default this is bind-address = 127.0.0.1 if you want to open to all then just comment out this line.Here's how to make sure that root has the correct permissions. My error message was similar and said ' Host XXX is not allowed to connect to this MySQL server' even though I was using root. I will make a Gaming Root P Server fr the Game Metin2. For any other action specify exactly the privileges you need and limit the accessibility of the user as Pascal has suggest below. Caut proiecte referitoare la Metin2 sau angajeaz pe cea mai mare pia de freelancing din lume. Hey Community, heute zeige ich euch wie ihr ein Metin2 Server auf einem FreeBSD Rootserver zum laufen bringen könnt. Votez toutes les 1h30 pour soutenir votre serveur prfr Les votes sont r-initialis le premier jour du mois. If you need an administrative user, use root, and leave it on localhost. Bienvenue sur Top-Metin2 Vous tes la recherche d'un serveur Metin 2 vous propose la liste des meilleurs serveurs privs Metin 2. Search and find the best Metin2 private servers ranked by votes, version, type using our top list and vote for your favourite. Mysql> CREATE USER IDENTIFIED BY 'some_pass' Īlthough as Pascal and others have noted it's not a great idea to have a user with this kind of access open to any IP. Mysql> GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Zarkana2 este cel mai bun server clasic de Metin2 PVM HARD - Intra acum si creeaza-ti propria legenda pe Zarkana2 Details. You could try adding a new administrator account: mysql> CREATE USER IDENTIFIED BY 'some_pass'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |