24.4.09 21:28 - remote access für mysql-Datenbank
in /etc/mysql/my.cnf Zeile bind-address = 127.0.0.1 auskommentieren
außerdem in mysql Rechteänderung für Benutzer:
z.B.
DROP TABLE IF EXISTS devs;
CREATE TABLE devs (
First_Name VARCHAR(30) NOT NULL,
Last_Name VARCHAR(30) NOT NULL,
Age INTEGER NOT NULL,
Gender CHAR NOT NULL,
id INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id)
);
INSERT INTO devs VALUES('Bill','Bloggs',25,'m',1);
INSERT INTO devs VALUES('Joe','Bloggs',26,'m',2);
INSERT INTO devs VALUES('Peter','Parker',39,'m',3);
INSERT INTO devs VALUES('Candy','Bliggs',19,'f',4);
INSERT INTO devs VALUES('Amber','Bliggs',27,'f',5);
INSERT INTO devs VALUES('Peter','Parker',49,'f',6);
grant all on *.* to root@'192.168.0.3' identified by 'a';
außerdem in mysql Rechteänderung für Benutzer:
z.B.
DROP TABLE IF EXISTS devs;
CREATE TABLE devs (
First_Name VARCHAR(30) NOT NULL,
Last_Name VARCHAR(30) NOT NULL,
Age INTEGER NOT NULL,
Gender CHAR NOT NULL,
id INTEGER NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id)
);
INSERT INTO devs VALUES('Bill','Bloggs',25,'m',1);
INSERT INTO devs VALUES('Joe','Bloggs',26,'m',2);
INSERT INTO devs VALUES('Peter','Parker',39,'m',3);
INSERT INTO devs VALUES('Candy','Bliggs',19,'f',4);
INSERT INTO devs VALUES('Amber','Bliggs',27,'f',5);
INSERT INTO devs VALUES('Peter','Parker',49,'f',6);
grant all on *.* to root@'192.168.0.3' identified by 'a';

