Script started on Mon Oct 21 12:27:16 2002 [barrie@magnolia barrie]$ pwd /home/barrie [barrie@magnolia barrie]$ ls evolution mysqlinstall20021018 syst-pkgcheckcmds mysqlinstall101802 mysqlinstalllast tmp [barrie@magnolia barrie]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE database HSLTEST; ERROR 1044: Access denied for user: '@localhost' to database 'HSLTEST' mysql> exit Bye [barrie@magnolia barrie]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.03 sec) mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql>show tables; +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | func | | host | | tables_priv | | user | +-----------------+ 6 rows in set (0.02 sec) mysql> describe user; +-----------------------+-----------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+-----------------------------------+------+-----+---------+-------+ | Host | varchar(60) binary | | PRI | | | | User | varchar(16) binary | | PRI | | | | Password | varchar(16) binary | | | | | | Select_priv | enum('N','Y') | | | N | | | Insert_priv | enum('N','Y') | | | N | | | Update_priv | enum('N','Y') | | | N | | | Delete_priv | enum('N','Y') | | | N | | | Create_priv | enum('N','Y') | | | N | | | Drop_priv | enum('N','Y') | | | N | | | Reload_priv | enum('N','Y') | | | N | | | Shutdown_priv | enum('N','Y') | | | N | | | Process_priv | enum('N','Y') | | | N | | | File_priv | enum('N','Y') | | | N | | | Grant_priv | enum('N','Y') | | | N | | | References_priv | enum('N','Y') | | | N | | | Index_priv | enum('N','Y') | | | N | | | Alter_priv | enum('N','Y') | | | N | | | Show_db_priv | enum('N','Y') | | | N | | | Super_priv | enum('N','Y') | | | N | | | Create_tmp_table_priv | enum('N','Y') | | | N | | | Lock_tables_priv | enum('N','Y') | | | N | | | Execute_priv | enum('N','Y') | | | N | | | Repl_slave_priv | enum('N','Y') | | | N | | | Repl_client_priv | enum('N','Y') | | | N | | | ssl_type | enum('','ANY','X509','SPECIFIED') | | | | | | ssl_cipher | blob | | | | | | x509_issuer | blob | | | | | | x509_subject | blob | | | | | | max_questions | int(11) unsigned | | | 0 | | | max_updates | int(11) unsigned | | | 0 | | | max_connections | int(11) unsigned | | | 0 | | +-----------------------+-----------------------------------+------+-----+---------+-------+ 31 rows in set (0.02 sec) mysql> select * from user; +-----------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +-----------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | localhost | root | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | magnolia.brighton.org | root | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | | magnolia.brighton.org | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | +-----------------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ 4 rows in set (0.03 sec) mysql> INSERT INTO user (Hostname, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(n0th1ng), Y, Y, Y, Y, Y, Y); ERROR 1054: Unknown column 'Hostname' in 'field list' mysql> INSERT INTO user (Hostname, User, Password, Select_priv, Insert_priv, Upda ate_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWOR RD(n0th1ng), Y, Y, Y, Y, Y, Y); mysql> select * from user; mysql> select * from user; ysql> INSERT INTO user (Hostname, User, Password, Select_priv, Insert_priv, Upda ate_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWOR RD(n0th1ng), Y, Y, Y, Y, Y, Y); ate_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSW mysql> INSERT INTO user (Hostname, User, Password, Select_priv, Insert_priv, Up, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORDysql> INSERT INTO user (Hostnam, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(ysql> INSERT INTO user (Hostna, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(nysql> INSERT INTO user (Hostn, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(n0ysql> INSERT INTO user (Host mysql>  mysql> INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_p priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(n0 0th1ng), Y, Y, Y, Y, Y, Y); ERROR 1054: Unknown column 'localhost' in 'field list' mysql> INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_p priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(n0 0th1ng), Y, Y, Y, Y, Y, Y); priv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost, barrie, PASSWORD(, barrie, PASSWORD(n0triv, Delete_priv, Create_priv, Drop_priv) VALUES (localhos, barrie, PASSWORD(n0thriv, Delete_priv, Create_priv, Drop_priv) VALUES (localho, barrie, PASSWORD(n0th1riv, Delete_priv, Create_priv, Drop_priv) VALUES (localh, barrie, PASSWORD(n0th1nriv, Delete_priv, Create_priv, Drop_priv) VALUES (local, barrie, PASSWORD(n0th1ngriv, Delete_priv, Create_priv, Drop_priv) VALUES (loca, barrie, PASSWORD(n0th1ng)riv, Delete_priv, Create_priv, Drop_priv) VALUES (loc, barrie, PASSWORD(n0th1ng),riv, Delete_priv, Create_priv, Drop_priv) VALUES (lo, barrie, PASSWORD(n0th1ng), riv, Delete_priv, Create_priv, Drop_priv) VALUES (l, barrie, PASSWORD(n0th1ng), Yriv, Delete_priv, Create_priv, Drop_priv) VALUES (m, barrie, PASSWORD(n0th1ng), [1@Yiv, Delete_priv, Create_priv, Drop_priv) VALUES (ma, barrie, PASSWORD(n0th1ng),[1@ iv, Delete_priv, Create_priv, Drop_priv) VALUES (mag, barrie, PASSWORD(n0th1ng)[1@,iv, Delete_priv, Create_priv, Drop_priv) VALUES (magn, barrie, PASSWORD(n0th1ng[1@)iv, Delete_priv, Create_priv, Drop_priv) VALUES (magno, barrie, PASSWORD(n0th1n[1@giv, Delete_priv, Create_priv, Drop_priv) VALUES (magnol, barrie, PASSWORD(n0th1[1@niv, Delete_priv, Create_priv, Drop_priv) VALUES (magnoli, barrie, PASSWORD(n0th[1@1iv, Delete_priv, Create_priv, Drop_priv) VALUES (magnoliz, barrie, PASSWORD(n0t[1@hiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnoliz, barrie, PASSWORD(n0thriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia, barrie, PASSWORD(n0t[1@hiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia., barrie, PASSWORD(n0[1@tiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.b, barrie, PASSWORD(n[1@0iv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.br, barrie, PASSWORD([1@niv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.bri, barrie, PASSWORD[1@(iv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brig, barrie, PASSWOR[1@Div, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brigh, barrie, PASSWO[1@Riv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.bright, barrie, PASSW[1@Oiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighto, barrie, PA [1@Sriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton, barrie, PAS[1@Siv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton., barrie, PAS[1@Sv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.o, barrie, P[1@Aiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.or, barrie, [1@Piv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org, barrie,[1@ iv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org, barri , PASSWORD(n0th1ng), Y, Y, Y, Y, Y, Y); ERROR 1109: Unknown table 'magnolia.brighton' in field list mysql> INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_p priv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org, barrie, , PASSWORD(n0th1ng), Y, Y, Y, Y, Y, Y);[1@'[1@'[1@'[1@'[1@' [1@'[1@'[1@'[1@'[1@' [1@'[1@')[1@'[1@' priv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org, barri [1@' priv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org, barri'barrie[1@'iv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org, '', 'barri[1@eiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.org'', 'barrieriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.or', 'barrie'riv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.o', 'barrie',riv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton.', 'barrie', riv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighton', 'barrie', 'riv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brighto', 'barrie', 'Priv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.bright', 'barrie', 'PAriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brigh', 'barrie', 'PASSiv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.brig', 'barrie', 'PASSriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.bri', 'barrie', 'PAS priv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.br', 'barrie', 'PASSWOriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.b', 'barrie', 'PASSWORriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia.', 'barrie', 'PASSWORDriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnolia', 'barrie', 'PASSWORD(riv, Delete_priv, Create_priv, Drop_priv) VALUES (magnoli', 'barrie', 'PASSWORD(nriv, Delete_priv, Create_priv, Drop_priv) VALUES (magnol', 'barrie', 'PASSWORD(n0riv, Delete_priv, Create_priv, Drop_priv) VALUES (magno', 'barrie', 'PASSWORD(n0triv, Delete_priv, Create_priv, Drop_priv) VALUES (magn', 'barrie', 'PASSWORD(n0thriv, Delete_priv, Create_priv, Drop_priv) VALUES (mag', 'barrie', 'PASSWORD(n0th1riv, Delete_priv, Create_priv, Drop_priv) VALUES (ma', 'barrie', 'PASSWORD(n0th1nriv, Delete_priv, Create_priv, Drop_priv) VALUES (m', 'barrie', 'PASSWORD(n0th1ngriv, Delete_priv, Create_priv, Drop_priv) VALUES (l', 'barrie', 'PASSWORD(n0th1n[1@giv, Delete_priv, Create_priv, Drop_priv) VALUES (lo', 'barrie', 'PASSWORD(n0th1[1@niv, Delete_priv, Create_priv, Drop_priv) VALUES (loc', 'barrie', 'PASSWORD(n0th[1@1iv, Delete_priv, Create_priv, Drop_priv) VALUES (loca', 'barrie', 'PASSWORD(n0t[1@hiv, Delete_priv, Create_priv, Drop_priv) VALUES (local', 'barrie', 'PASSWORD(n0[1@tiv, Delete_priv, Create_priv, Drop_priv) VALUES (localh', 'barrie', 'PASSWORD(n[1@0iv, Delete_priv, Create_priv, Drop_priv) VALUES (localho', 'barrie', 'PASSWORD([1@niv, Delete_priv, Create_priv, Drop_priv) VALUES (localhos', 'barrie', 'PASSWORD[1@(iv, Delete_priv, Create_priv, Drop_priv) VALUES (localhost', 'barrie', 'PASSWOR[1@Div, Delete_priv, Create_priv, Drop_priv) VALUES (localhost'localhost', 'barrie', 'PASSWO[1@Riv, Delete_priv, Create_priv, Drop_priv) VALUES ('localhost', 'barrie', 'PASS ORD(n0th1ng)', 'Y','Y', 'Y', 'Y', 'Y', 'Y'); Query OK, 1 row affected (0.03 sec) mysql> select * from user; +-----------------------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +-----------------------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | localhost | root | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | magnolia.brighton.org | root | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | | magnolia.brighton.org | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | | localhost | barrie | PASSWORD(n0th1ng | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | +-----------------------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ 5 rows in set (0.04 sec) mysql> UPDATE user SET Password=PASSWORD('n0th1ng') where User='barrie' and Host='localhost'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from user; +-----------------------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +-----------------------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | localhost | root | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | magnolia.brighton.org | root | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | | magnolia.brighton.org | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | | localhost | barrie | 08b5e2265589eab3 | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | +-----------------------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ 5 rows in set (0.02 sec) mysql> exit Bye [barrie@magnolia barrie]$ whoami barrie [barrie@magnolia barrie]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE database HSLTEST; ERROR 1044: Access denied for user: '@localhost' to database 'HSLTEST' mysql> m exit Bye [barrie@magnolia barrie]$ mysql -u barrie -p Enter password: ERROR 1045: Access denied for user: 'barrie@localhost' (Using password: YES) [barrie@magnolia barrie]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.03 sec) mysql> CREATE database HSLTEST; Query OK, 1 row affected (0.02 sec) mysql> show tables; ERROR 1046: No Database Selected mysql> show databases; +----------+ | Database | +----------+ | HSLTEST | | mysql | | test | +----------+ 3 rows in set (0.02 sec) mysql> CREATE TABLE eid; ERROR 1046: No Database Selected mysql> use HSLTEST; Database changed mysql> CREATE TABLE EID (id tinyint(  auto     (3), title varchar(255), url varchar(255)[1@1[1@0[1@0[1@5[1@0), url varchar(255)); Query OK, 0 rows affected (0.02 sec) mysql> show tables -> ; +-------------------+ | Tables_in_HSLTEST | +-------------------+ | EID | +-------------------+ 1 row in set (0.02 sec) mysql> describe EID; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | id | tinyint(3) | YES | | NULL | | | title | varchar(150) | YES | | NULL | | | url | varchar(255) | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ 3 rows in set (0.02 sec) mysql> INSERT INTO EID (id, title, url) VALEU  UES ('1', MEDLINE[1@'MEDLINE', 'http://www.    www.uncl e.unc.edu/skrt/uncle/eid/ovidOnline.pl?D=mesz'); Query OK, 1 row affected (0.02 sec) mysql> select * from EID; +------+---------+--------------------------------------------------------------+ | id | title | url | +------+---------+--------------------------------------------------------------+ | 1 | MEDLINE | http://www.uncle.unc.edu/skrt/uncle/eid/ovidOnline.pl?D=mesz | +------+---------+--------------------------------------------------------------+ 1 row in set (0.02 sec) mysql> INSERT INTO EID (id, title, url) VALUES (2, 'PUBMED', 'httpd://www.uncle.unc.edu/skrt/uncle/eid/pubmed.pl'); Query OK, 1 row affected (0.02 sec) mysql> select * from EID -> ; +------+---------+--------------------------------------------------------------+ | id | title | url | +------+---------+--------------------------------------------------------------+ | 1 | MEDLINE | http://www.uncle.unc.edu/skrt/uncle/eid/ovidOnline.pl?D=mesz | | 2 | PUBMED | http://www.uncle.unc.edu/skrt/uncle/eid/pubmed.pl | +------+---------+--------------------------------------------------------------+ 2 rows in set (0.02 sec) mysql> INSERT INTO EID (id, title, url) VALUES (3, 'CINAHL', 'http://www.uncle.un nc.edu/skrt/uncle/eid/ovidOnline.pl?D=nursing'); mysql> select * from EID; +------+---------+-----------------------------------------------------------------+ | id | title | url | +------+---------+-----------------------------------------------------------------+ | 1 | MEDLINE | http://www.uncle.unc.edu/skrt/uncle/eid/ovidOnline.pl?D=mesz | | 2 | PUBMED | http://www.uncle.unc.edu/skrt/uncle/eid/pubmed.pl | | 3 | CINAHL | http://www.uncle.unc.edu/skrt/uncle/eid/ovidOnline.pl?D=nursing | +------+---------+-----------------------------------------------------------------+ 3 rows in set (0.00 sec) mysql> exit Bye [barrie@magnolia barrie]$ mysqldump HSLTEST > hsltest.sql mysqldump: Got error: 1044: Access denied for user: '@localhost' to database 'HSLTEST' when selecting the database [barrie@magnolia barrie]$ sudo Password: mysqldump: Got error: 1045: Access denied for user: 'root@localhost' (Using password: NO) when trying to connect [barrie@magnolia barrie]$ mysqldump -u root -p HSLTEST > hsltest.sql Enter password: [barrie@magnolia barrie]$ ls evolution mysqlinstall101802 mysqlinstalllast tmp hsltest.sql mysqlinstall20021018 syst-pkgcheckcmds [barrie@magnolia barrie]$ more hsltest.sql -- MySQL dump 9.06 -- -- Host: localhost Database: HSLTEST --------------------------------------------------------- -- Server version 4.0.3-beta-max -- -- Table structure for table 'EID' -- CREATE TABLE EID ( id tinyint(3) default NULL, title varchar(150) default NULL, url varchar(255) default NULL ) TYPE=MyISAM; -- -- Dumping data for table 'EID' -- INSERT INTO EID VALUES (1,'MEDLINE','http://www.uncle.unc.edu/skrt/uncle/eid/ovi dOnline.pl?D=mesz'); --More--(70%) INSERT INTO EID VALUES (2,'PUBMED','http://www.uncle.unc.edu/skrt/uncle/eid/pubm ed.pl'); INSERT INTO EID VALUES (3,'CINAHL','http://www.uncle.unc.edu/skrt/uncle/eid/ovid Online.pl?D=nursing'); [barrie@magnolia barrie]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.03 sec) mysql> use test; Database changed mysql> CREATE TABLE user(id tinyint(3), lname varchar(20), fname varchar(20)); Query OK, 0 rows affected (0.02 sec) mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | user | +----------------+ 1 row in set (0.02 sec) mysql> insert into user (id, lname, fname) values (1, hayes,' barrie'); Query OK, 1 row affected (0.02 sec) mysql> select * from user; +------+-------+--------+ | id | lname | fname | +------+-------+--------+ | 1 | hayes | barrie | +------+-------+--------+ 1 row in set (0.02 sec) mysql>drop table user mysql> exit Bye [barrie@magnolia barrie]$ mysqldump -u barrie -p test > test.sql Enter password: mysqldump: Got error: 1045: Access denied for user: 'barrie@localhost' (Using password: YES) when trying to connect [barrie@magnolia barrie]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from user; +------+-------+--------+ | id | lname | fname | +------+-------+--------+ | 1 | hayes | barrie | +------+-------+--------+ 1 row in set (0.03 sec) mysql> drop table user; Query OK, 0 rows affected (0.03 sec) mysql> show tables; Empty set (0.02 sec) mysql> exit Bye Script done on Mon Oct 21 13:35:16 2002 Script started on Mon Oct 21 13:40:33 2002 [barrie@magnolia barrie]$ [barrie@magnolia barrie]$ mysql ERROR 1045: Access denied for user: 'barrie@localhost' (Using password: NO) [barrie@magnolia barrie]$ mysql -u barrie ERROR 1045: Access denied for user: 'barrie@localhost' (Using password: NO) [barrie@magnolia barrie]$ mysql -u barrie -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 4.0.3-beta-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | HSLTEST | | barries | | mysql | | test | +----------+ 4 rows in set (0.03 sec) mysql> use barries Database changed mysql> drop barries -> ; ERROR 1064: You have an error in your SQL syntax near 'barries' at line 1 mysql> drop database barries -> ; Query OK, 0 rows affected (0.03 sec) mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tabels   les; +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | func | | host | | tables_priv | | user | +-----------------+ 6 rows in set (0.02 sec) mysql> CREATE database barries -> ; Query OK, 1 row affected (0.02 sec) mysql> show tables; +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | func | | host | | tables_priv | | user | +-----------------+ 6 rows in set (0.02 sec) mysql> show databases; +----------+ | Database | +----------+ | HSLTEST | | barries | | mysql | | test | +----------+ 4 rows in set (0.01 sec) mysql> exit Bye Script done on Mon Oct 21 14:04:53 2002