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