LinuxQuestions.org - mysql troubles

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - mysql troubles (https://www.linuxquestions.org/questions/linux-software-2/mysql-troubles-236468/)

alright
i just installed slackware 10 and now im trying to get mysql going.
i have mysql running
i need to make a new user
so i go to my terminal and and try to get in as root but i get an error. so i try it as a normal user and i get in.

here's the code:

Code:

eth0real@zero-cool:~$ su

Password:

root@zero-cool:/home/eth0real# mysql

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

root@zero-cool:/home/eth0real# exit

exit

eth0real@zero-cool:~$ mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 10 to server version: 4.0.20

ok so now im in i guess but when ever i use and commands and try to add users i get the following

ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

what's going on?
as you can probably tell i dont know too much about mysql.

thanks

did you set password on your mysql root user or not yet?
if u did ? u need t log in as mysql root:

mysql -u root -p
password:

this way u have permision on everything in mysql. i don't believe its the right way to do things because you should assign a regular user some permission to be able to do those sorts of tasks instead of the root. but this will work