Subject: mysql-3.21.29-gamma
To: users current <current-users@NetBSD.ORG>
From: Tom T. Thai <tomthai@future.net>
List: current-users
Date: 04/26/1998 19:27:53
I finally had some time to play with mysql-3.21.29-gamma on
NetBSD1.2g/i386. Compile was fine. Install was fine. mysql_install_db
seemed fine.
# mysqlshow
mysqlshow: Host is not allowed to connect to this MySQL server
# mysql -u root mysql
ERROR 1130: Host is not allowed to connect to this MySQL server
/etc/hosts does contain:
127.0.0.1 localhost
# more dream.log
mysqld started on Sun Apr 26 16:11:01 CDT 1998
/usr/local/install/mysql-3.21.29-gamma/libexec/mysqld, Version:
3.21.29-gamma-lo
g, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/usr/local/install/mysql-3.21.29-gamma/libexec/mysqld: ready for
connections
980426 16:11:06 1 Connect root@localhost.future.net on
1 Statistics
1 Quit
980426 16:11:07 2 Connect root@localhost.future.net on
2 Init DB mysql
2 Query delete from db
2 Query delete from host
2 Query delete from user
2 Query delete from func
2 Query INSERT INTO db VALUES
('%','test','','Y','Y','
Y','Y','Y','Y')
2 Query INSERT INTO db VALUES
('%','test\_%','','Y','Y
','Y','Y','Y','Y')
2 Query INSERT INTO host VALUES
('localhost','%','Y','
Y','Y','Y','Y','Y')
2 Query INSERT INTO host VALUES
('dream','%','Y','Y','
Y','Y','Y','Y')
2 Query INSERT INTO user VALUES
('localhost','root',''
,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
2 Query INSERT INTO user VALUES
('localhost','','','N'
,'N','N','N','N','N','N','N','N','N')
2 Query INSERT INTO user VALUES
('dream','root','','Y'
,'Y','Y','Y','Y','Y','Y','Y','Y','Y')
2 Query INSERT INTO user VALUES
('dream','','','N','N'
,'N','N','N','N','N','N','N','N')
2 Quit
980426 16:11:08 3 Connect root@localhost.future.net on
3 Reload
3 Quit
hostname returns:
# hostname
dream
Everything looks good, but why would it let me connect to the mysql
server? Client mysql is on the same host as the server.
.............. ....................................
Thomas T. Thai Infomedia Interactive Communications
tom@iic.net TEL 612.376.9090 * FAX 612.376.9087