i'm stumped ~ mysql no connect

[jmcqueen]

hi:

i have my testing server set up (FC3) and i am attempting to connect to a mysql db that i created in gnome-db. i set the db up and the connect string looks good, however when i attempt to connect with the username and password, i get:

* Connection to Database failed
Access denied for user: 'myuser@localhost' (Using password: YES)

anyone have any ideas?

any help would be appreciated.

j

[luma]

does myuser@localhost have access to the database in question?

you can either grant ALLL priviliges to that user globally (insecure) or give him persmision to just the databases you want him access to, make sure he has either one of the other.

are you connecting from a difernet host or from localhost?

Luc

[jmcqueen]

yes, i am creating the db with gnome-db and the connect string is good. when i check /var/lib/mysql i am not seeing the db i created in gnome. it is appearing in the gnome queue. yes, i am connecting as localhost.

still no luck.

help,
john

[luma]

what about the user? mysql by default won't give a new user access to nothing, you need to gran this user access.

or use root@localhost..

I never used gnome-db so no clue about it.

I use my sql command line and Phpmyadmin to admister the database so I can't help you specialy with gnome-db.

Luma

[jmcqueen]

thank you. so, how do i create a db and assign a username from the command line?

j

[luma]

let see if I can remember

go to a shell.

type mysql -u root -p

it will give you
enterpassword:
so enter the mysql root password....

create database nameofdatabasehere; (press enter)
Query OK, 1 row affected (0.00 sec)

now type
GRANT ALL (pressenter)
>ON newdatabasenewhere.* (press enter)
>TO newusername@localhost; (press enter)
Query OK, 0 rows affected (0.02 sec)

this new user DOES NOT HAVE A PASSWORD. so lets give him one.
mysqladmin -u molly -p password NEWPASSWORD

exit

so here you have created a database called nameofdatabasehere (I hope you cahnge this )
then granted ALL persmision so that new database to newusername (hope you cahnge this too ) at localhost

btw localhost users can only connect from you guess it. the localhost (that computer only)

Luma

[jmcqueen]

i tried this and all i get is:

Error 1045: Access denied for user: 'root@localhost' (Using password: YES)


i'm logged at the command prompt as root.

what gives?


john

[luma]

what is your mysql root password? (don't type it here but I hope you know this.)
you need to reorganise man, you need to know at least some stuff, you need user id and password of a WORKING account on the database

Luma

[jmcqueen]

i have been using su - and logging in as root and various other usernames with no problems. for instance, right now i am logged in at the term window as

[root@linuxbox mysql]

this is the prob: as a user or as a su -, i am being told that access is denied.

could it be in the setup of mysql server and how do i go about making the changes to enable me as a user?


j

[luma]

mysql is completely seperate users then the computer itself.

try root as mysql user without password...

Luma