RE: i'm just missing something
Look at GRANT Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stick Dragon [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 22:34 To: [EMAIL PROTECTED] Subject: i'm just missing something I been tring to read the docs on the website, and tried looking it up, but i'm getting confused. I am trying to make a database and a user. to make the database i use mysql> create database dbname; that seems to work. but how do i make a user for it? _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: i'm just missing something
Actually there is a slightly better way to add a user. Read the following entry in the mysql docs: http://www.mysql.com/doc/en/GRANT.html In fact you might want to read this whole section: http://www.mysql.com/doc/en/User_Account_Management.html Example: grant select, insert on *.* to joeuser@localhost identified by "some_password"; This command does a bunch of other things like add permissions to the db table and encrypt the password in the user table. Sometimes it is faster to hack the user and db tables directly, but it is still not a good practice. I hope this helps. Thanks, Matt Matthew P Baranowski Data Manager, Office of Educational Assessment University of Washington - Original Message - From: Steve Vernon <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 2:44 PM Subject: Re: i'm just missing something > There is a mysql database with a user table in it. > > Add a new user, then reload the database! Remember to password the password. > > And it will work! > > > I been tring to read the docs on the website, and tried looking it up, but > > i'm getting confused. I am trying to make a database and a user. > > to make the database i use > > > > mysql> create database dbname; > > > > that seems to work. but how do i make a user for it? > > > > _ > > Add photos to your e-mail with MSN 8. Get 2 months FREE*. > > http://join.msn.com/?page=features/featuredemail > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: i'm just missing something
There is a mysql database with a user table in it. Add a new user, then reload the database! Remember to password the password. And it will work! > I been tring to read the docs on the website, and tried looking it up, but > i'm getting confused. I am trying to make a database and a user. > to make the database i use > > mysql> create database dbname; > > that seems to work. but how do i make a user for it? > > _ > Add photos to your e-mail with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php