Raised This Month: $32 Target: $400
 8% 

Solved help me in mysql connection


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Loyal_ty
Junior Member
Join Date: Oct 2020
Location: techno world
Old 08-07-2021 , 21:49   help me in mysql connection
Reply With Quote #1

Hello guys.

i am using levels ranks plugin on my CS:GO server.
plugin link : https://forums.alliedmods.net/showthread.php?t=318782

plugin is using sqlite by default
i wanna change sqlite to mysql so i added the following codes to Database.cfg file.

Code:
"levels_ranks"
{
		"driver"		"mysql"
		"host"			"localhost"
		"database"		"lvl_ranks"
		"user"			"my_username"
		"pass"			"my_password"
}
after adding this to my cfg file plugin wont work,
also i added lvl_ranks database to phpmyadmin but still no tables.

plugin cant work because its not connected to mysql server.

i have a wordpress test project that is connected to mysql and is working correctly :
Code:
define( 'DB_NAME', 'wordpress' );
define( 'DB_USER', 'my_username' );
define( 'DB_PASSWORD', 'my_password' );
define( 'DB_HOST', 'localhost' );
define( 'DB_CHARSET', 'utf8mb4' );
+ i tried this for host too :
Code:
"host" "localhost/phpmyadmin"
__________________
♠ ▬ 0X03 ▬ ♠

Last edited by Loyal_ty; 08-19-2021 at 20:27.
Loyal_ty is offline
Loyal_ty
Junior Member
Join Date: Oct 2020
Location: techno world
Old 08-19-2021 , 20:29   Re: help me in mysql connection
Reply With Quote #2

finally i found the problem:

in phpmyadmin user settings i changed Authentication plugin from SHA256 password authentication to Native MYSQL authentication and it fixed everything.
__________________
♠ ▬ 0X03 ▬ ♠
Loyal_ty is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:51.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode