Re: [PHP] Users of RDBMS
On Fri, 10 Sep 2004 03:07:35 +0530, Mulley, Nikhil [EMAIL PROTECTED] wrote: You can create user from mysql prompt by connecting it through first cmdmysql -h host -u userid -p instance password : ** then type GRANT ALL PRIVILGES ON *.* TO 'newuser'@'host' IDENTIFIED BY 'password' with GRANT OPTION; where newuser is new users id and host may be either localhost or any other host,if you want to add that user to connect from any host then replace 'host' with '%' with single quotes. and password is new users password. Regards Nikhil Please, please, please, do not use *.* and with GRANT OPTION for any user you may want to create. Usually: GRANT all ON dbname.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; does the trick, while *.* and with GRANT OPTION creates a new superuser for the database. Also, I'd advice to explicitly specify the host from which this user is allowed to login (don't use the '%'). Especially when you're creating a superuser ;). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
John Nichel wrote: M. Sokolewicz wrote: John Nichel wrote: Joshua D. Drake wrote: PHP != MySQL MySQL != RDBMS Please tell me you're kidding. that's a funny one... could've sworn it actually was one... All this time the MySQL AB people have been lying to us. It's actually an Excel spreadsheet. ;) Well RDBMS things like Foreign Key's and constraints used to be documented but did not actually work, so what else was not provided ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Users of RDBMS
You can create user from mysql prompt by connecting it through first cmdmysql -h host -u userid -p instance password : ** then type GRANT ALL PRIVILGES ON *.* TO 'newuser'@'host' IDENTIFIED BY 'password' with GRANT OPTION; where newuser is new users id and host may be either localhost or any other host,if you want to add that user to connect from any host then replace 'host' with '%' with single quotes. and password is new users password. Regards Nikhil -Original Message- From: Victor Saldaña D. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 1:03 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Users of RDBMS On Wed, 8 Sep 2004 12:01:55 -0700 (PDT), Pahlevanzadeh Mohsen [EMAIL PROTECTED] wrote: Dears, I need to create user for MySQL. Please guide me.. Please RTFM http://dev.mysql.com/doc/mysql/en/Adding_users.html -- Victor Saldaña D. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Users of RDBMS
Dears, I need to create user for MySQL. Please guide me.. = -DIGITAL SIGNATURE--- ///Mohsen Pahlevanzadeh Network administrator programmer My home phone is: +98213810146 My email address is m_pahlevanzadeh at yahoo dot com My website is: http://webnegar.net __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
On Wed, 8 Sep 2004 12:01:55 -0700 (PDT), Pahlevanzadeh Mohsen [EMAIL PROTECTED] wrote: Dears, I need to create user for MySQL. Please guide me.. Please RTFM http://dev.mysql.com/doc/mysql/en/Adding_users.html -- Victor Saldaña D. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
From: Pahlevanzadeh Mohsen [EMAIL PROTECTED] I need to create user for MySQL. Please guide me.. PHP != MySQL http://dev.mysql.com/doc/mysql/en/index.html ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Users of RDBMS
[snip] I need to create user for MySQL. Please guide me.. [/snip] I will guide you to the MySQL lists at http://lists.mysql.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
On Wed, 2004-09-08 at 14:01, Pahlevanzadeh Mohsen wrote: Dears, I need to create user for MySQL. Please guide me.. http://dev.mysql.com/doc/mysql/en/Adding_users.html -- Greg Donald -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
Dears, I need to create user for MySQL. Please guide me.. = -DIGITAL SIGNATURE--- ///Mohsen Pahlevanzadeh Network administrator programmer My home phone is: +98213810146 My email address is m_pahlevanzadeh at yahoo dot com My website is: http://webnegar.net Dear, Please go here: http://lists.mysql.com/ Jim Grill -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
PHP != MySQL MySQL != RDBMS http://www.postgresql.org http://dev.mysql.com/doc/mysql/en/index.html ---John Holmes... -- Co-Founder Command Prompt, Inc. The wheel's spinning but the hamster's dead -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
Pahlevanzadeh Mohsen wrote: Dears, I need to create user for MySQL. Please guide me.. I keep forgetting that this it the MySQL list. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Users of RDBMS
-Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:37 PM To: Pahlevanzadeh Mohsen; [EMAIL PROTECTED] Subject: RE: [PHP] Users of RDBMS [snip] I need to create user for MySQL. Please guide me.. [/snip] I will guide you to the MySQL lists at http://lists.mysql.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I should share this image I found... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Users of RDBMS
Hi, PHP != MySQL http://dev.mysql.com/doc/mysql/en/index.html Shouldn't that be: if ( PHP != MySQL ) { Header( Location: http://dev.mysql.com/doc/mysql/en/index.html; ); } -Dan Joseph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
Joshua D. Drake wrote: PHP != MySQL MySQL != RDBMS Please tell me you're kidding. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
John Nichel wrote: Joshua D. Drake wrote: PHP != MySQL MySQL != RDBMS Please tell me you're kidding. that's a funny one... could've sworn it actually was one... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
M. Sokolewicz wrote: John Nichel wrote: Joshua D. Drake wrote: PHP != MySQL MySQL != RDBMS Please tell me you're kidding. that's a funny one... could've sworn it actually was one... All this time the MySQL AB people have been lying to us. It's actually an Excel spreadsheet. ;) -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Users of RDBMS
On Wed, 8 Sep 2004 13:14:57 -0700 (PDT), Joshua D. Drake [EMAIL PROTECTED] wrote: MySQL != RDBMS http://www.postgresql.org Yup. I recently became a Postgres user after 5+ years using MySQL. I am very impressed with it so far. The price is right and the license is very friendly for all. -- Greg Donald http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php