Jump to content


Photo

Newbie Question


  • Please log in to reply
1 reply to this topic

#1 kentish

kentish
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 17 June 2003 - 10:48 PM

Hiya.
How do i set up the username and p/w on a new mysql db?

Many thanks in advance for your help.

Kind regards

Andrew :lol:

#2 rhysmeister

rhysmeister
  • Members
  • PipPipPip
  • Advanced Member
  • 51 posts
  • LocationEngland

Posted 24 June 2003 - 10:08 AM

You can do this by using the GRANT statement i.e.

GRANT ALL PRIVILEGES ON *.* to \'username@localhost\' IDENTIFIED BY \'password\';

There are various variations on this depending on what you want to do. FOr a full explanation check out...

http://www.mysql.com...ding_users.html




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users