mysql troubles

Algernon · 09-28-2004, 11:00 PM

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

m2azer · 09-28-2004, 11:06 PM

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