SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 20/01/2017, 11:38 AM   #1
Ahmed21
Big Clucker
 
Join Date: Jul 2016
Posts: 158
Reputation: 3
Default mysql plugin

Hello everyone,

I've run my gamemode, I've scripted it like two years ago, it uses the include file "mysql" (not a_mysql), and the plugin mysql.dll

When I run the server on my localhost, it says: Access denied for 'root'@'localhost' ....

Here's OnGameModeInit callback:

PHP Code:
public OnGameModeInit()
{
    
connection mysql_init(LOG_ONLY_ERRORS1);
    
     
mysql_connect("localhost""root""""cnr"connection1);
     return 
1;

Ahmed21 is offline   Reply With Quote
Old 20/01/2017, 01:12 PM   #2
Eloy
Huge Clucker
 
Join Date: May 2016
Location: Venezuela
Posts: 260
Reputation: 4
Default Respuesta: mysql plugin

Check if the virtual host allow your connection or change your password root user
Eloy is offline   Reply With Quote
Old 20/01/2017, 05:24 PM   #3
azzerking
Huge Clucker
 
azzerking's Avatar
 
Join Date: Dec 2009
Location: England, Leicestershire
Posts: 482
Reputation: 72
Default Re: mysql plugin


1. Make sure your MYSQL server is running
2. Make sure the password and account is correct
3. Make sure you have granted access for the user to connect locally
4. Make sure you have access to the table and the commands ( SELECT, UPDATE, DELETE, INSERT )
5. Try accessing the database from another source.
__________________
Web Skill: PHP, HTML, CSS, JS, RUBY, NODE.js.

Programing Skill: Objective C, C#, C++, D#, Python, Java, MySQL, Rust, Go

OS Skill: Windows (95 - 10), Ubuntu/Debian, Raspbian, Kali, Arch, Unix, Mac (E-MACs - Current)

Scripting Skill: LUA, Pawn, C38*
azzerking is offline   Reply With Quote
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[MySQL] From StickenKid's plugin to BlueG's plugin jessejanssen Scripting Help 2 15/06/2014 01:20 AM
BlueG MySQL plugin - Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 10:56 AM
MySQL Plugin R5 plugin problem dud Scripting Help 12 05/12/2011 06:28 PM
[help][plugin] Can't load mysql plugin mariomako Help Archive 8 16/07/2011 02:37 PM
mysql plugin. loading plugin failed ikkentim Help Archive 2 10/02/2011 02:32 PM


All times are GMT. The time now is 07:50 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.