On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote: > Hi, I have just setup a dedicated linux/php/mysql dev box in my office > and I am gearing up to move my databases from a windows box to the > linux box. There are a couple of things I would like to be clear on > before I start.
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. > 2) can somebody, anybody offer up some links to a quicky tutorial on > loading a database with existing data, and backing up an existing > database. I don't mean the ones in the mysql manual, I am looking for > more of a "made for dorks like me" version. "MySQL" by Paul DuBois (New Riders). Sorry I don't have a web reference, but this book is very helpful. Erik --------------------------------------------------------------------- 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
