Điều này cho MySQL để đăng nhập bạn vào như là gốc người sử dụng và yêu cầu mật khẩu của bạn. Nếu bạn có một mật khẩu, nhập nó, nếu không, chỉ cần nhấn trở lại. Một khi bạn đã đăng nhập, gõ như sau để kiểm tra chương trình, bạn sẽ thấy như hình 8-3 phản ứng: SHOW cơ sở dữ liệu; | 0 O 0 Terminal mysql 80x24 Last Login Wed Nov 26 11 35 14 on ttypl S Welcome to Darwin Unknown-00-0d-93-87-37-3d robinnixon Applications MAMP Library bin mysql -u root -p Enter password Welcome to the MySQL monitor. Commands end with or g. Your MySQL connection id is 18 to server version Type help or h1 for help. Type c to clear the buffer. mysql show databases 4------------------- I Database I 4------------------4- I information_schema I I mysq I I I test I 4------------------- 3 rows in set sec mysqI Figure 8-2. Accessing MySQL from the Mac OS X Terminal program enter the examples in the next section. But first you should type the following to log in to your MySQL system mysql -u root -p This tells MySQL to log you in as the user root and to request your password. If you have a password enter it otherwise just press Return. Once you are logged in type the following to test the program you should see something like Figure 8-3 in response SHOW databases If this procedure fails at any point please refer to the section Installing a LAMP on Linux on page 25 in Chapter 2 to ensure that you have MySQL properly installed. Otherwise you should now be ready to move on to the next section Using the Command-Line Interface on page 163. MySQL on a remote server If you are accessing MySQL on a remote server you should Telnet or preferably for security use SSH into the remote machine which will probably be a Linux FreeBSD Unix type of box. Once in there things may be a little different for you depending on how the system administrator has set the server up especially if it s a shared hosting server. Therefore you need to ensure that you have been given access to MySQL and Accessing MySQL via the Command Line 161 You may also use sysinstall 8 to re-enter the installation and configuration utility. Edit etc motd to change this login announcement. robnix mysql -u root -p Enter password Welcome to the MySQL monitor. Commands end with or g. Your MySQL connection id is .
