S.L.C

I mentioned this issue already. Google for something such as "debian allow remote mysql connection". Some of those guides should tell you how to create users that allow you to connect from remote hosts.

Follow whichever you want. The official server is a bit more outdated but promises more stability. Although that stability might only be applicable to MTA (from what I've seen so far). Where as the second option installs a more recent version but you should be careful about not breaking compatibility with MTA. Personally, I'd go with the second option because I'm more used to it and I know what to expect. And if the second option poses any issues you can always remove it and install the official version instead.

Have you installed the MySQL server? There are two options. The one from the official repositories or the more recent one from the Dotdeb repositories. Official: Dotdeb:

What I'm about to recommend is a major security issue and I wouldn't recommend it to anyone that wants a secure server. But the reason I will recommend this to you is that the thought of you setting up a web server with PHP enabled and setting up a phpMyAdmin instance is giving me chills right now. The only other way I'd know to help is to install some control panel on the VPS or via team-viewer. So let's begin. Edit the file located in /etc/mysql/my.cnf and change the port to a random number that is different than the default port. Then edit the address to which the MySQL server binds to the IP address assigned to your VPS. After you edit and save the file. Restart your server via the following command line: service mysql restart Or simply reboot your VPS. Also, be sure to update the IP address and port you set in the my.cnf file in your Lua code as well. After you've done that you can connect to your MySQL server from the outside world (that's why this is a security issue!). And you can do that with the HeidiSQL software. So download that, install it and open it. Then add your server and connect to it. You can create databases/tables and execute SQL queries after you connect to your MySQL server. Please note that some MySQL installations disable root connections from the outside world. So if your server happens to have that enabled then you can try to connect as much as you want but you'll fail every time. You must either enable root authentication from the outside world (bad idea!) or create a new MySQL user and use that.

You don't have to just install Screen. You also need to open a session in Screen and then start the server in that Screen session. And then detach from that screen session. Which let's it run in the background for you to attach later. As described in that guide with also contains a brief . Did you even read that guide or you simply ignored it like everyone else does.

Dunno. But if you really have to ask me that... I'd say there's plenty.

apt-get install screen I get that you're new but for the love of god man. Learn the basics first and then move on to what you're trying to do. Otherwise you're on a straight path to ignore questions everywhere.

Damn, it's like a never ending cycle down here. Just stick to playing people if you can't google or haven't touched a server in your life.

Download WinSCP. Add your VPS, connect into it. and manage your files.

Again, the wiki is your friend. Introduction to Resources.

Do you have the MySQL server installed and and started? Do you have the database created and a user that can access and/or modify that database? Normally you should check the 'sql' (bad choice of naming though!!!) against NULL values to be sure you have a working connection before you even try anything else. Validate things people! You're working with a weakly typed language.

Not sure where you got that idea but that's not the road you want to take. Somehow you skipped the first two links in the wiki and reached to the building part which isn't really meant for server owners unless they want to tweak or develop stuff. Although I find the wiki to be pretty straight forward about the installation so I'm not sure that that's the problem here. Getting a precompiled package Installing and Running MTASA Server on GNU Linux And if you still don't manage to install it then you should probably stick to playing. Most people do that. I've never even tried an MTA server or even to play for that matter. But the wiki was so clear and specific about doing things that it took me a few minutes to adjust.

Make sure you have an updated OS. apt-get update && apt-get dist-upgrade Make sure you installed the MySQL server. apt-get install mysql-server As for that library that you're looking for. I believe it can be found in the Squeeze distribution of Debian. And to install packages from older distributions. You need to edit your sources.list file to include those older distributions as well. Although I don't think that's the solution for this case. Because the MySQL server that comes with your current distribution (5.5?) wouldn't like working with libraries from your older distribution (5.1?). I don't know what's your current situation and I haven't developed anything with the MySQL module so I wouldn't exactly know what to recommend.

I gave you that link for a reason. And you can't randomly download any shared library and expect it to work. What architecture was it compiled for and more importantly what architecture was your server compiled for? (x32/x64?) Under what operating system do you run your server? Under what distribution? (Debian/CentOS?) What architecture is your operating system? etc. You can't just pop a question like "My dog died and I want to know why!" and expect me to give you an appropriate answer. Jeezus people, if you can't ask a question properly and/or you're not capable of understanding the answer then why even bother.

screen?