Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Tue Hellstern on January 05, 2002, 07:11:44 PM

Title: MySql Access
Post by: Tue Hellstern on January 05, 2002, 07:11:44 PM

Hi,
I am trying to get access to MySql using a Windows program, mysqlfront.
I have to select the following information, but I can’t get it to connect.

Hostname/IP
User
Password
Port

User and Password are right, I have tried them directly on the server, and I got access.
It is the Hostname and the Port  I don’t know.
The local IP of my server is 192.168.0.1
What Port number shall I use?

Tue

Title: Re: MySql Access
Post by: Confucius on January 06, 2002, 07:04:36 PM

Use the default port by NOT filling in anything and you will see that it will work for you.

Harro

Title: Re: MySql Access
Post by: Tue Hellstern on January 06, 2002, 08:29:01 PM

Hi Harro,
I have tryed NOT filling anything in port, but it dont work

I  get this:

Host 'pc-00069' is not allowed to connect to this MySql Server

I have 2 users nuke and root

Tue

Title: Re: MySql Access
Post by: Darren on January 07, 2002, 06:58:00 AM

what you have to do is allow your computer to access the database this is a table called db  in mysql
INSERT INTO db VALUES('ip address of your machine' , 'Database name',  'Username', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y')

this should sort it.
if you want to give access to all use %

Title: Re: MySql Access
Post by: Tue Hellstern on January 07, 2002, 02:09:36 PM

Hi,
I tried;

GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH GRANT OPTION;

and that work.

Tue