http://dev.mysql.com/doc/mysql/en/Adding_users.html
mysql> GRANT ALL PRIVILEGES ON db.*
-> TO mysql@'192.168.10.0/255.255.255.0'
-> IDENTIFIED BY 'mysql123';
--
Ritter
Kirti S. Bajwa wrote:
Hello:
I am trying to setup a client mysql server to connect to a Master MySQL
server by MUST using a PASSWOR
I did the following (not much different):
CREATE TABLE `foo` (
`pri_1` INT UNSIGNED NOT NULL,
`pri_2` INT UNSIGNED NOT NULL,
`pri_3` INT UNSIGNED NOT NULL,
`test_data` VARCHAR(120) NOT NULL,
PRIMARY KEY (`pri_1`, `pri_2`, `pri_3`)
) TYPE = InnoDB;
Regards,
Ritter
--
Jason k Larson
