Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

MYSQL problem

Quote Reply
MYSQL problem
Hi All,

I tired to install mysql database for using linksSQL. But I even can't create user. I installed the rpm version. Here is what the error message:

[root@myserver /home]# su mysql
[mysql@myserver /home]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21 to server version: 3.22.27

Type 'help' for help.

mysql> GRANT usage
-> ON adcycle.*
-> TO adcycle@localhost;
ERROR 1044: Access denied for user: '@localhost' to database 'adcycle'
mysql>

I just don't knw what's going wrong. Can any one give me some directions?



------------------
Bear EveryWhere
Quote Reply
Re: MYSQL problem In reply to
You haven't logged into the mysql server.

It doesn't seem to know who you are.

Try logging in with:

mysql -u -p

it should prompt you for a username and password. When you do this, you'll be recognized by the sql server, and you should be able to make changes.