Is it by default possible to have 2 logins and 2 passwords for sql access?
What would be the best way to solve it if not? Making a sql2.cfg, change cvar names and add the new login and pw for that database and change the plugins to use those?
I want this to be able to give another person access to the second db, but not the first.
sql.cfg
Code:
amx_sql_host "127.0.0.1"
amx_sql_user "user1"
amx_sql_pass "password1"
amx_sql_db "database1"
amx_sql_table "amxx"
sql2.cfg
Code:
amx_sql2_host "127.0.0.1"
amx_sql2_user "user1"
amx_sql2_pass "password2"
amx_sql2_db "database2"