i'm stumped ~ mysql no connect

[jmcqueen]

yes, i tried and none of the usernames will work. all are denied by mysql.

where do i go to get MYSQL users set up?

j

[luma]

you have to use the root account (of sql)
here let me say one thing first

your machines users (root, you test ETCETC) HAVE NOTHING ZIP NADA!!! to do with mysql. remember this

if you just installed sql, then there is no root password.

so follow my instructions from a few threads back but don't use the -p

Luma

[jmcqueen]

hi luma:

i have done everything in the above thread, but i still get an 'Access denied...." error and the db creation fails.

any ideas?


j

[luma]

yes, you are using the wrong user ID and password for SQL,

is this YOUR server? or someone elses?

how did you install mysql?

type this:
mysql -u root

copy and paste the output
example:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


answer all above questions please, makes it easier to help.

Luma

[jmcqueen]

thank you for all of your help. here is the output:

[root@jmcqueen ~]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 66 to server version: 3.23.58

Type 'help;' or '/h' for help.  Type '\c' to clear the buffer.

mysql>

yes, this is my personal server i am running as a dual boot with. sql was installed during the FC3 install i did a few months ago. i have verified that it is running by checking 'servces'.

i really do appreciate all of your help. i just don't know where to go from here. this thing should work.

j

[luma]

by doing that command it worked, you are loged into sql by the looks of it

I do the same as you but I need a password and I get the same thing.
[root@rh-as-svr root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 292 to server version: 4.1.12-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


ok now

create database nameofdatabasehere; (press enter)

replace nameofdatabasehere wiht whatever you want ot name your database. lets say "testdb1"
then
create database testdb1; (enter key)

tell me what you get when you do this.

and not a problem for the help, I am at work and bored and I like to help,

Luma

[jmcqueen]

i have to get to mysql> by not using a password. otherwise i get an access denied

...
...
ERROR 1044: Access denied for user: '@localhost' to database 'zenit'
mysql>

[luma]

ya that is ok you are now loged into mysql and ready to create the user and database

we can set a password on root after but make sure it works first
do this...

ok now

create database nameofdatabasehere; (press enter)

replace nameofdatabasehere wiht whatever you want ot name your database. lets say "testdb1"
then
create database testdb1; (enter key)

tell me what you get when you do this.



Luma

[jmcqueen]

ok, i got the db named 'zenit' created, but now i can't get the password changed. i created it as 'root'. the system gives an error when i try to change the password:

[root@jmcqueen mysql]# mysqladmin -u root -p password
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
[root@jmcqueen mysql]#

[luma]

try this instead
from the mysql> promp type:

SET PASSWORD FOR root@localhost=PASSWORD('newpasswordhere');

make sure to triple check your spelling..

capital Sensitive