SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Evangelist
    Join Date
    Apr 2002
    Posts
    523
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    user name and password

    Hi how are you doing ? I am doing my sql but I don't know how to make user name and password into my sql.

    actually I did like this:

    mysql -u itohideo -p<japan.sql

    Pleae tell me the codes for username and password.

  2. #2
    SitePoint Guru Husain's Avatar
    Join Date
    Sep 2001
    Posts
    620
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you created a username "itohideo"?

    If not, then you must log in as root and create a username first. To log in as root just type "mysql" and press enter. Then create a username using this statement:

    GRANT ALL PRIVELEGES ON *.* TO itohideo@localhost IDENTIFIED BY yourpassword;

    On successful execution of the above statement you can log in to MySQL using the statement:

    > mysql -h localhost -u itohideo -p

    Hope this helps.


Bookmarks

Posting Permissions

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