MySql

EsTeEm1 · - Joined: 24 Jan 2006 Posts: 5

Hey..

I recently created my own ftp/web server and ive been wanting to create a forum using invison or phpbb. I tryed installing mysql and creating a database for my forum. But when im in the forums setup it keep saying it cant connect to mysql. I have all my ports forwarded and mysql is running. The only thing i cant understand is that people say you suppose to go into the bin folder and click a ms dos file that launches mysql. I tryed that and i dont see no traffic light at all on the system tray. But it shows in my processes that mysql is running. So i am stumped i have php installed on my webserver, i have my setup file all ready for my forum i want to install but for some reason it wont connect to the mysql database.

If you need to know what i have for php and mysql i have mysql 5.0 the newest version and php's newest version

Thanks please help me i would love to have my forums up and running some day

aprelium · - Joined: 22 Mar 2002 Posts: 6800

EsTeEm1,

The bin folder was present in old MySQL version. The new one has an installer that does all the job without requiring any manual steps.

What is the exact version of PHP you are using? If you are using PHP 4 than the error makes sense since PHP 4.x is not compatible with MySQL 4.1 and higher (including 5.x). Search for "error 1251" on this forum and you'll get more information about the problem.
_________________
Support Team
Aprelium - http://www.aprelium.com

EsTeEm1 · - Joined: 24 Jan 2006 Posts: 5

I have version 5.1 and i dont get any errors from the db it says its running when i use the mysql administrator. But the installer for the forums is saying it cant connect to the db. I think its because it isn't making the user/pass and the database?

olly86 · - Joined: 25 Apr 2003 Posts: 993 Location: Wiltshire, UK

EsTeEm1 · - Joined: 24 Jan 2006 Posts: 5

I tryed making a mysql use/pass and new database from tutorials i have found on websites includeing here. is there a way to check to see if i did it correctly? or is there a better tutorial you can get?

i just need help with it in general if you cant explain it to me on here could you please add me to msn or aim so i cna get live support please?

thanks

EsTeEm1 · - Joined: 24 Jan 2006 Posts: 5

Well mysql is running...

when i try to install my forum it comes up with...

This comes up when i try to connect to database mysql
user= root
pass= my pass

Warning!

The following errors must be rectified before continuing!
Please go back and try again!

INSERT INTO ibf_task_manager VALUES ('', 'Update Topic Views Counter', 'updateviews.php', 1138150540, -1, -1, 3, -1, 'ddce954b5ba1c163bc627ca20725b595', 0, 'Used when topic views are not incremented immediately', 1, 'updateviews', 0, 0);

Out of range value adjusted for column 'task_id' at row 1

Meanwhile for phpmyadmin i get

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

because i cant edit my config.ini.php file because apperently i dont have one

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

You're using MySQL v5 which some applications don't support yet. This whole
compatibility thing with PHP and MySQL is completely rediculous. You may try
installing MySQL v4.1 if your using PHP v5 and that should fix it.

Sincerely, TRUSTpunk