MySQL soll im Netzwerk erreichbar sein

Irgendwelche Probleme mit XAMPP für Linux? Dann ist hier genau der richtige Ort um nachzufragen.

MySQL soll im Netzwerk erreichbar sein

Postby ahorn » 01. September 2006 07:38

Vielleicht spart es jemandem Zeit ...

Vorliegende Netzwerkkonfiguration:
Lampp liegt auf 192.168.0.2
Rechner zur Anwendungsentwicklung hat 192.168.0.1

Aufruf der DB vom Entwicklungsrechner erzeugt:
Host '192.168.0.1' hat keine Berechtigung, sich mit diesem MySQL-Server zu verbinden

Das ist auf dem Linuxrechner zu ändern mit:

/opt/lampp/bin/mysql_setpermission --host localhost --user <<root>>

Danach habe ich das Script folgendermaßen abgearbeitet:

Password for user root to connect to MySQL: <<pwd eingeben>>

######################################################################
## Welcome to the permission setter 1.3 for MySQL
## made by Luuk de Boer
######################################################################
What would you like to do:
1. Set password for an existing user
2. Create a database + user privilege for that database
and host combination (user can only do SELECT)
3. Create/append user privilege for an existing database
and host combination (user can only do SELECT)
4. Create/append broader user privileges for an existing
database and host combination
(user can do SELECT,INSERT,UPDATE,DELETE)
5. Create/append quite extended user privileges for an
existing database and host combination (user can do
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
LOCK TABLES,CREATE TEMPORARY TABLES)
6. Create/append database administrative privileges for an
existing database and host combination (user can do
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,
CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS)
7. Create/append full privileges for an existing database
and host combination (user has FULL privilege)
8. Remove all privileges for an existing database and
host combination.
(user will have all permission fields set to N)
0. exit this program

Make your choice [1,2,3,4,5,6,7,8,0]: <<7 eingeben>>


Which database from existing database would you like to select:
You can choose from:
- information_schema
- cdcol
- mysql
- phpmyadmin
- test
Which database will it be (case sensitive). Type * for any:
<<* eingeben>>
OK, the user entry will NOT be limited to any database
What username is to be created: <<root eingeben>>
Username = root
Would you like to set a password for root [y/n]: <<y eingeben>>
What password do you want to specify for root: <<pwd eingeben>>
Type the password again: <<pwd eingeben>>
We now need to know from what host(s) the user will connect.
Keep in mind that % means 'from any host' ...
The host please: 192.168.0.1
######################################################################

That was it ... here is an overview of what you have gave to me:
The database name : *
The username : root
The host(s) : 192.168.0.1
######################################################################

Are you pretty sure you would like to implement this [y/n]: <<yes eingeben>>
Okay ... let's go then ...

Everything is inserted and mysql privileges have been reloded.

######################################################################
## Welcome to the permission setter 1.3 for MySQL
## made by Luuk de Boer
######################################################################
What would you like to do:
1. Set password for an existing user
2. Create a database + user privilege for that database
and host combination (user can only do SELECT)
3. Create/append user privilege for an existing database
and host combination (user can only do SELECT)
4. Create/append broader user privileges for an existing
database and host combination
(user can do SELECT,INSERT,UPDATE,DELETE)
5. Create/append quite extended user privileges for an
existing database and host combination (user can do
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
LOCK TABLES,CREATE TEMPORARY TABLES)
6. Create/append database administrative privileges for an
existing database and host combination (user can do
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,
CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS)
7. Create/append full privileges for an existing database
and host combination (user has FULL privilege)
8. Remove all privileges for an existing database and
host combination.
(user will have all permission fields set to N)
0. exit this program

Make your choice [1,2,3,4,5,6,7,8,0]: <<0 eingeben>>
We hope we can help you next time

Danach ging alles

Andreas
alles was man kann ist einfach
ahorn
 
Posts: 1
Joined: 31. August 2006 16:01

Return to XAMPP für Linux

Who is online

Users browsing this forum: No registered users and 17 guests