Thank you Eric and Mike, I really appreciate the help!
>From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: "Curtis Gordon" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: just moved from windows to linux mysql >Date: Thu, 06 Dec 2001 13:50:52 -0600 > >Just to add a few side notes. > >We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be >very >stable and very reliable. :) > >We have approx., 30+ clients that use the one of the MySQL servers, and we >set >up each client with a .my.cnf in each of the respective root directories: > >/home/<user_name>/.my.cnf > >so when they login thru the shell, all they need to do is type in at the >prompt: > >$bash mysql > >and they are logged into their database. We do use their UN*X account >username >and password, as they find this easier then trying to remember separate >username/password or password to access the MySQL client. > >This has worked very well for us :) > > > >On Thu, 6 Dec 2001 14:46:19 -0500, Erik Price <[EMAIL PROTECTED]> >wrote: > > >>Good move. > >> > >>> 1) when I am logged into linux as "user1" and I create a database, >does > >>> this mean that my username and password for the database will be the > >>> same as the linux login, or do you have to set username and password > >>> when you are creating the database? > >> > >>Some people are confused by the way MySQL keeps track of users because > >>MySQL also features a user called "root" (like in Unix/Linux). But be > >>assured that you must create your users in MySQL (using GRANT commands) > >>separate from your Unix/Linux users. For sake of ease, you can use the > >>same names, but you don't have to. If you're in Linux, logged in as > >>User1, you can log in to MySQL as User55 like this: > >> > >>$ bin/mysql -u User55 -p samp_db > >> > >>or you can just let the mysql client program assume that you want to log > >>in to MySQL under the same name as your current Linux username (User1) > >>like this: > >> > >>$ bin/mysql -p samp_db > >> > >>see? Omit the -u argument and the mysql client uses your Unix/Linux > >>username as the MySQL username. Note that the -p flag is optional if > >>you do not have a password set for that particular MySQL account. > >Mike(mickalo)Blezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >Thunder Rain Internet Publishing >Providing Internet Solutions that work! >http://www.thunder-rain.com >Tel: 1(225)686-2002 >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- 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
