Find the answer to your Linux question:
Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 25
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...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #11
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql


    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

  2. #12
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    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

  3. #13
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

    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

  4. $spacer_open
    $spacer_close
  5. #14
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    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

  6. #15
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

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

    Code:
    [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

  7. #16
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    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

  8. #17
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

    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>

  9. #18
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    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

  10. #19
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql

    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]#

  11. #20
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    try this instead
    from the mysql> promp type:

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

    make sure to triple check your spelling..

    capital Sensitive

Page 2 of 3 FirstFirst 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •