Not connecting to mysql!

[rusztamas]

Hello these are the things what i wrote to my newly installed ubuntu server:

sudo apt-get install mysql-server 

--filled in

sudo apt-get install apache2 

--filled in

sudo apt-get install phpmyadmin 

--filled in

vim /etc/apache2/apache2.conf 

Include /etc/phpmyadmin/apache.conf

[phpMYADMIN, MYSQL-SERVER, APACHE WEBSERVER IS WORKING]

I put libmysql.so.16 into the main directory, (where the mta-server64 file is) and in to the mods/deathmatch folder too.

mtaserver.conf loads mta_mysql.so, which is in the x64/modules folder.

I imported the .sql file to the phpMyAdmin too, without any problems.

The script outputted to my chatbox, that the registration was successfull, and no failure was detected. But i can register 200x times with the same infos, that means, it won't insert the registration infos to the database. What can i do here?

[ccw]

What resource is outputting 'the registration was successfull' ?

[rusztamas]

Social Gaming's mysql resource. Shall i send the whole script to you?

[Mr_Moose]

I suppose you use the new Ubuntu 16 which comes with the same mysql-client package as Debian 8+ which does not include the file: libmysqlclient.so.16. You should download that file and put it in /usr/lib in order to allow mysql connections from your server.

Feel free to use this bash script to quickly get the file in place if you want.

wget [url=https://repos.99stack.com/mtasa/libraries/libmysqlclient.so]https://repos.99stack.com/mtasa/librari ... lclient.so[/url].16 
sudo cp libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16 
rm libmysqlclient.so.16 

For verification here's the sha1 checksum: 6af02ee0af044fcb57a0a9bec4067542876ea110