Find the answer to your Linux question:
Page 3 of 3 FirstFirst 1 2 3
Results 21 to 25 of 25
mysql> SET PASSWORD FOR root@localhost=PASSWORD('xxxxxx'); Query OK, 0 rows affected (0.00 sec) mysql>...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #21
    Just Joined!
    Join Date
    Jan 2005
    Posts
    20

    mysql


    mysql> SET PASSWORD FOR root@localhost=PASSWORD('xxxxxx');
    Query OK, 0 rows affected (0.00 sec)

    mysql>

  2. #22
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    there you go

    you have now created a database manualy and changed the root password

    you should now be able to connect to said database using root and your newpassword using whatever you where working on before you ran into the connection problem

    now its time to have fun and use your new database

    if you want to eventualy use this database for external use I would suggest creating a new user and NOT using root but that is for later...

    Luma

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

    mysql

    thank you. please tell me if you can surf to the following url.

    http://24.166.228.140/thegemzone/catalog/index.php

  4. $spacer_open
    $spacer_close
  5. #24
    Just Joined!
    Join Date
    May 2005
    Posts
    97
    yes I can see the website just fine.

    2 problems show up at the top though in red but there not related to SQL in any way.


    I suggest you install and use phpmyadmin to manage your databases unless you want to learn the command line stuff like we did today, but no one will hold your hand for EVERYTHING, I got you started you should be ok for now.

    if you plan on working more and more with SQL , adding sql users, adding databases then you should look into phpmyadmin

    its easy to install but you NEEEEEDDDD to read the manual for phpmyadmin, if you don't it will be installation problem after problem, but if you follow the install documents it should be easy and straight forward and phpmyadmin is a VERY powerfull tool.

    I am almost done my shift so I Am done for today

    Luma

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

    mysql

    thank you so much for ALL of your help! i truly do appreciate this.

    regards,
    john

Page 3 of 3 FirstFirst 1 2 3

Posting Permissions

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