Topic: MySql Access

[Tue Hellstern]

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

[Confucius]

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

Harro

[Tue Hellstern]

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

[Darren]

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 %

[Tue Hellstern]

Hi,
I tried;

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

and that work.

Tue