Using MySQL to Adjust Settings for Jump Assist

Post Reply
volpics
New to forums
New to forums
Posts: 2
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Mon Oct 21, 2013 5:24 am

Using MySQL to Adjust Settings for Jump Assist

Post by volpics »

Hi,

A newer version of the Jump Assist program requires the use of MySQL to create a database for the plugin. However I haven't been able to use the phpMyAdmin tool to do the steps needed. Would anyone know how to do this? I have the steps needed ripped from the guide below.
3) Create the MySQL database - MANDATORY !!! (I don't know if it works with sqlite)

Of course, MySQL is already installed on your server.

3.a) Create the empty database :
Code: [Select]

mysqladmin -u root -p create jumpassist


3.b) Open the MySQL console to create a new user to access the database (optionnal but REALLY recommanded for security reasons) :

Code: [Select]

mysql -u root -p mysql


In the MySQL console create the user (and permissions) :

Code: [Select]

GRANT ALL ON jumpassist.* TO jumpassist@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
exit


Change the 'password' by a real password diffrent from roots' one.
Don't forget the ; at the end of the lines.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Using MySQL to Adjust Settings for Jump Assist

Post by soja »

Do you have webhosting here at Nfo? If so you should be able to create the database and install phpnyadmin right from your control panel
Not a NFO employee
volpics
New to forums
New to forums
Posts: 2
Joined: Mon Oct 21, 2013 5:24 am

Re: Using MySQL to Adjust Settings for Jump Assist

Post by volpics »

I do. It's mostly the last part that I have trouble with.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Using MySQL to Adjust Settings for Jump Assist

Post by soja »

Add me on steam, easier to help that way:

http://steamcommunity.com/id/soja992
Not a NFO employee
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Using MySQL to Adjust Settings for Jump Assist

Post by soja »

We solved this issue by going through the databases.cfg for sourcemod, verifying the settings, and making sure "Allow external connections" was checked in the NFO control panel.
Not a NFO employee
Post Reply