I'm trying to learn about Mysql, so I need to get a database up and running to start to understand it.
I'm having trouble authenticating into the data base (not a very good omen hehe)
Here is what I've done--
Built mysql
Started mysqld (confirmed with nmap)
Ran the install script (as root):
/usr/bin/mysql_install_db
Everthing seems ok--it gives instructions to set a password
/usr/bin/mysqladmin -u root -p password new-password
Enter password:
I enter password--everythings ok
Here is where the problem starts, I try to:
root@Duron800 dan # mysql -u root -p test
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
dan@Duron800 dan $ mysqlshow
+-----------+
| Databases |
+-----------+
| test |
+-----------+
Im kinda stuck--I've done dozons of things. The above are just the highlights--I've done the above as root and as a user.
Any thoughts?
