Mysql noob questions, problems authenticating
 

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?




:)

root@Duron800 dan # mysql -h 127.0.0.1 -uroot -pBlaBlaBal666
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)


Stole this from another thread

Hmm