AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Off-Topic (https://forums.alliedmods.net/forumdisplay.php?f=15)
-   -   Cant connect to mysql wtf? (https://forums.alliedmods.net/showthread.php?t=299180)

4ever16 07-06-2017 04:02

Cant connect to mysql wtf?
 
Hello i dont understand i just cant connect to my own mysql.
Im running a plugin which conencts to mysql.
But every time it says cant connect to mysql.

What i have done.
Added remote accces so that mysql server can accept acces from the server.
Added all right information.

#define MIX_HOST "mysql adress"
#define MIX_USER "database username"
#define MIX_PASSWORD "password"
#define MIX_DATABASE "database name"


I have tryied to test mysql connection. This code which uses mysqli works.

PHP Code:

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php
$dbname 'X';
$dbuser 'X';
$dbpass 'X';
$dbhost 'X';
$link mysqli_connect($dbhost$dbuser$dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link$dbname) or die("Could not open the db '$dbname'");
$test_query "SHOW TABLES FROM $dbname";
$result mysqli_query($link$test_query);
$tblCnt 0;
while(
$tbl mysqli_fetch_array($result)) {
  
$tblCnt++;
  
#echo $tbl[0]."<br />\n";
}
if (!
$tblCnt) {
  echo 
"There are no tables<br />\n";
} else {
  echo 
"There are $tblCnt tables<br />\n";
}
?>

This code to test with mysql code doesnt work.

PHP Code:

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php
$dbname 'name';
$dbuser 'user';
$dbpass 'pass';
$dbhost 'host';
$connect mysql_connect($dbhost$dbuser$dbpass) or die("Unable to Connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the db '$dbname'");
$test_query "SHOW TABLES FROM $dbname";
$result mysql_query($test_query);
$tblCnt 0;
while(
$tbl mysql_fetch_array($result)) {
  
$tblCnt++;
  
#echo $tbl[0]."<br />\n";
}
if (!
$tblCnt) {
  echo 
"There are no tables<br />\n";
} else {
  echo 
"There are $tblCnt tables<br />\n";
}
?>

The PHP version of my database/php my admin is 5.6.30.

So what do you think the problem is why cant amxx plugins connect to the mysql?
Do i need changes in the plugin code so that it uses msqli instead of msql?

Rohanlogs 07-06-2017 09:37

Re: Cant connect to mysql wtf?
 
Hi. Your amxx plugin can't connect to the database?
Can you provide source code of that plugin?
It's also better to use constants rather than defines.

4ever16 07-06-2017 10:25

Re: Cant connect to mysql wtf?
 
Found out that my host didnt allow remote acces but it sed clearly in cpanel that its allowed.


All times are GMT -4. The time now is 01:19.

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