TAILIEUCHUNG - Phát triển web với PHP và MySQL - p 22

Creating Your Web Database CHAPTER 8 185 2. Have access to MySQL on a machine that you do not administer such as a Web hosting service, a machine at your workplace, and so on. If this is the case, in order to work through the examples or to create your own database, you’ll need to have your administrator set up a user and database for you to work with and tell you the username, password, and database name they have assigned to you. You can either skip the sections of this chapter that explain how to set up users and databases or. | Creating Your Web Database 185 Chapter 8 2. Have access to MySQL on a machine that you do not administer such as a Web hosting service a machine at your workplace and so on. If this is the case in order to work through the examples or to create your own database you ll need to have your administrator set up a user and database for you to work with and tell you the username password and database name they have assigned to you. You can either skip the sections of this chapter that explain how to set up users and databases or read them in order to better explain what you need to your system administrator. As a normal user you won t be able to execute the commands to create users and databases. The examples in this chapter were all built and tested with MySQL version . Some earlier versions of MySQL have less functionality. You should install or upgrade to the most current stable release at the time of reading. You can download the current release from the MySQL site at http . A Note on Using the MySQL Monitor You will notice that the MySQL examples in this chapter and the next end each command with a semicolon . This tells MySQL to execute the command. If you leave off the semicolon nothing will happen. This is a common problem for new users. This also means that you can have new lines in the middle of a command. We have used this to make the examples easier to read. You will see where we have done this because MySQL provides a continuation symbol. It s an arrow that looks like this mysql grant select - This means MySQL is expecting more input. Until you type the semicolon you will get these characters each time you press Enter. Another point to note is that SQL statements are not case sensitive but database and table names can be more on this later. How to Log In to MySQL To do this go to a command line interface on your machine and type the following mysql -h hostname -u username -p Your command prompt might look different depending on the operating

TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.