Mysql Help

[Jguy101 0]

I'm currently trying to install MyTopix forum software, but when I give it my information for the MySQL database I've created for it, I get an error saying it can't access the database because I gave it incorrect information. Now, I'm positively sure I gave it the right version, username, password, and database name, so that leaves the server location fo the database, and the server port.

 

So, what would the database location and the server port be?

 

Thanx.

[NilsC 0]

I have no clue what your domain name or user name is so I'm going to use a generic one

 

When you create a mySQL database the database name and username are prefixed with (in my case) nilsc_ so the db name could be nilsc_mytopix if you called the db mytopix

 

Whatever database name you create is prefixed with your username and an undescore.

 

The same thing happens with the user name you create. You didn't put what you called the db, or what if, if any error message you had.

 

The more specific you are and the more info you give will make it easier to provide a solution!

but when I give it my information for the MySQL database I've created for it, I get an error saying it can't access the database because I gave it incorrect information.

What information did you give (I don't mean password), what did the error message say?

did you look in php my admin? did you look at the sample code created in MySQL Databases (including the connect format)

Nils

[miCRoSCoPiC^eaRthLinG 0]

Hi,

Can't say much about it - till I know the exact error message - but try again and this time do the following in MySQL. Remove the prior database first. This might not be a solution - but this is the FIRST and FOREMOST step you should follow when you are trying to setup a forum sw.

 

====================

mysql> create database YourForumDatabaseName;

 

mysql> grant all on YourForumDatabaseName.* to 'admin'@'localhost' identified by 'YourPassword';

 

AND ALSO

mysql> grant all on YourForumDatabaseName.* to 'admin'@'10.19.168.%' identified by 'YourPassword';

====================

 

Of course replace "YourForumDatabaseName" with your forum's database name (follow the naming convention nilsc has used here, by appending your name with underscore before the database name - that's like a standard for all of them) and "admin" and "YourPassword" with your admin name and password for the db. In the third line, replace my IP (10.19.168.5) with yours and make sure you OMIT the LAST SEGMENT and use a "%" in place of it. The "%" acts like a WildCard character and ensures that mysql will accept connection from any node on your network hosting your forum software, which means both your forum and mysql DOESN'T have to reside on the same machine and physically can be on two different nodes on the same network.

 

Then try to connect from the myTopix installation page again. This happened to me in phpBB2 - the mysql access rights were configured properly - so it persistently refused to let phpBB connect.

 

All the best