VDS arma 3 sql

[DustinK]

hello I need help like really badly, so I need to get mysql working to make is so i can get my arma 3 altis life server going, i have been going on multiple tutorials, these are some https://ariejan.net/2007/12/12/how-to-i ... ntudebian/ when i go through this one there is this one part that asks me do to this command "sudo mysqladmin -u root -h localhost password 'mypassword' " but it doesnt really work at all, this is the result dustin@pgdevserver:~$ sudo mysqladmin -u root -h localhost password 'mypassword'
sudo: unable to resolve host pgdevserver
[sudo] password for dustin:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
dustin@pgdevserver:~$, i have followed every tutorial more than once if anyone can help me my steam name is =PG= Dustin, and my teamspeak is 216.52.148.117. If someone does get this working for me I will make sure to repay you from the fullest of my abilities!

Cheers,
Dustin

[Spray]

Did you happen to run through a different tutorial that installed MySQL previously? The command you're running is doing the following:

sudo mysqladmin

Run mysqladmin as a super user.

-u root -h localhost

Connect to MySQL running on the local machine using the root user account with no password specified.

password 'mypassword'

Set the password to 'mypassword' for the user account you're connecting with.

The error you're getting is telling you that you either don't have a root@localhost account setup or that you need to use a password for this account.

Did you previously create a user account for MySQL? If so, you don't need to follow this step of the tutorial you're using. If not, you may need to reset the root password for MySQL. The MySQL website has a guide for this here: http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html

[DustinK]

ok so should mysql be working now, or am i doing somthing else wrong cause when i try to use navi cat it does not work?

[DustinK]

ok so should mysql be working now, or am i doing somthing else wrong cause when i try to use navi cat it does not work?

i got it to connect with my friends help, but now we get this error,

Code: Select all

DB CONNECT ERROR: Access denied for user 'arma1'@'208.146.35.34' to database 'arma3life'
Fatal error: Call to undefined function logString() in /usr/www/pgarma3/public/controlpanel/include/db.php on line 12

[DustinK]

ok so this is interesting i have the error after i join goto the map and hit continue it says

Code: Select all

Sending request to server for player information UID [thenmydi]
The server didnt find any player information matching  your UID, Attempting to add player to system

and it just does that constantly, quite fast

any help?

[Spray]

It sounds like the in-game message you're getting is a result of the previous error message:

DB CONNECT ERROR: Access denied for user 'arma1'@'208.146.35.34' to database 'arma3life'

Please ensure that your "arma1" user has been given permission to access this database from this IP address.

Here is an example of a query that would allow this (run this command as root or as a user with the grant option):

Code: Select all

GRANT ALL ON arma3life.* TO 'arma1'@'208.146.35.34';

[$atanic $pirit]

I would suggest you to install phpmyadmin tool. It will make things a lot easier, if you don't like command line stuff.

Now, if your database and server is on same VDS, then try to use internal IP. I have found success using internal IP more often that external, especially if you are on gentoo.

Code: Select all

Use: 127.0.0.1 for IP

[DustinK]

It sounds like the in-game message you're getting is a result of the previous error message:

DB CONNECT ERROR: Access denied for user 'arma1'@'208.146.35.34' to database 'arma3life'

Please ensure that your "arma1" user has been given permission to access this database from this IP address.

Here is an example of a query that would allow this (run this command as root or as a user with the grant option):

Code: Select all

GRANT ALL ON arma3life.* TO 'arma1'@'208.146.35.34';

after i did that command it still did not work got anything else

thee mysql database and the arma 3 server are on different servers