Author Topic: Setting up MySql (Read 7006 times)

Gwitz · « **on:** December 24, 2005, 09:07:28 am »

Ok, so im new to guild/raidbots and php and mysql...but so far i think i have everything, im getting the "Can't connect to MySql server on 'Localhost' " error, and im sure i just dont have the mysql database setup properly.

So..iv been trying all sorta of stuff iv been seering by searching old posts...but i just cant get the comands to work the in my sql command window...so im sure im doing something wrong :\

Gwitz · « **Reply #1 on:** December 24, 2005, 09:22:43 am »

Also like to add...windows machine, mysql and everything is on the same machine

Khalem · « **Reply #2 on:** December 24, 2005, 02:59:31 pm »

I'm planning to write up a Windows guide, but until then i have never even installed MySQL on windows, so I'm afraid i cant be of too much help.

However i can recommend a windows MySQL administration tool that i use extensively to administrate my own MySQL databases, regardless of what OS the database is run on.
It should make things easier for those that can't quite find their way around the command line tools.
http://www.webyog.com/sqlyog/index_sqlyogfree.php

Xenixa · « **Reply #3 on:** December 24, 2005, 10:42:48 pm »

Couple things with Security settings on Windows machines you will need to check wi MySQL.

First to make it easier to adjust Security settings get the MySQL Administrator program from the MySQL website if you havn't already. Once it's all installed and you're connected to the Server using the root account goto "Startup Variables" On the Security Tab the ONLY box on that tab that should be checked on is the "Disable Grant Tables".

Double check to make sure "Use Old Passwords" is not checked on. That will give you headaches from hell if your running off a Windows server.

Hope all that helps.

Gwitz · « **Reply #4 on:** December 25, 2005, 04:01:38 am »

Well, iv obviously got soemthing setup wrong in the mysql install or something, cuz the admin tool u suggested gives a similar error as the bebot prompt. Can't connect to MYsql server on localhost. Im possitive i have the password correct cuz its the same one i use to logon the mysql command line.

Alreadythere · « **Reply #5 on:** December 25, 2005, 02:18:46 pm »

Got any local firewall running?
If yes, are local processes allowed to open connections to MySQL?

skeezix · « **Reply #6 on:** December 25, 2005, 06:15:12 pm »

I would imagine the most common error when setting up MySQL is the firewall is killing access to itself. If you're running on XP/2003 go to the firewall settings and add either the executable for MySQL that is running, or add the specific port you're running MySQL on.

If it's an authentication error I would imagine it would say, otherwise I'm assuming a firewall issue

Gwitz · « **Reply #7 on:** December 26, 2005, 02:13:08 am »

Well i got mysql working, i reckon the first time i installed mysql i tried to use a different password from the sign in part...so anyways i deleted the entire mysql folder and ya it works now. But now im getting authentication error from bebot. My friend says it has somethin to do with the php.ini file.

Khalem · « **Reply #8 on:** December 26, 2005, 03:08:52 pm »

This will be what you're looking for:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

The mysql library that comes with your php is most likely a 4.0 version which means it doesn't understand the new password format in MySQL 4.1 and newer.
That webpage details the ways to get around it.

Gwitz · « **Reply #9 on:** January 15, 2006, 11:25:18 am »

A friend sent me a bebot install with php and everything already in it, and it works. cool bot all in all, now i gota learn php so i can start doin customizing. I also read the mysql tutorial on editing the database, very cool stuff so far.

First thing that stands out to me is that i have to make members superadmin in order for them to be able to take !leader in the raidbot. Also, anyone can use the !loot and !result functions.

if anyone knows of a good php tutorial it would be much appreciated

Xenixa · « **Reply #10 on:** January 15, 2006, 04:08:33 pm »

Tutortial eh? Well no better place to start than the source of all that is PHP.

http://us2.php.net/manual/en/index.php There's a Tutorial in the Manual with lots of links to other sources.

How I learned anyway.

Well actually I started by looking at code samples that listed what they do. What I did was to look at them and deconstruct them function by function and then read up on the PHP commands in the Manual used in those functions. BeBot's code is a good way to learn actually. It actually uses a very small set of PHP's commands. Narrow enough to give you a good foundation on how the PHP parser operates I think.

Balneator · « **Reply #11 on:** February 12, 2006, 02:22:07 pm »

Having similar problems myself probably due to being generally clueless on what to type in where, when i run bebot i get "call to undefined function mysql_connect() in c:\*bebot folder*\mysql.php, also same as gwitz can't get the SQLyog thing to connect or the SQL setup thing

MatHack · « **Reply #12 on:** February 12, 2006, 03:59:24 pm »

That sounds like a misconfigured PHP, means it can't find the mysql_connect() function, which is located in the mysql-extension.

Balneator · « **Reply #13 on:** February 12, 2006, 05:09:58 pm »

yeah i was completely unsure of what to type into the $dbase $user $pass and $server into the MySQL.conf and then tried the SQLyog thing, just not sure what i'm doing really, i first found out mySQL existed yesterday...still not entirely sure what it does

Balneator · « **Reply #14 on:** February 13, 2006, 12:36:57 am »

ok poked around a bit more, understand what i'm trying to do now but the values i'm using appear to be wrong according to that error atm i have
<?
$dbase = "raidbot";
$user = "<username>";
$pass = "<password>";
$server = "%Localhost";
?>
does that seem correct?

Author Topic: Setting up MySql (Read 7006 times)

Gwitz

Setting up MySql

Gwitz

Re: Setting up MySql

Khalem

Re: Setting up MySql

Xenixa

Re: Setting up MySql

Gwitz

Re: Setting up MySql

Alreadythere

Re: Setting up MySql

skeezix

Re: Setting up MySql

Gwitz

Re: Setting up MySql

Khalem

Re: Setting up MySql

Gwitz

Re: Setting up MySql

Xenixa

Re: Setting up MySql

Balneator

Re: Setting up MySql

MatHack

Re: Setting up MySql

Balneator

Re: Setting up MySql

Balneator

Re: Setting up MySql