Unit IX: Setting Up a MySQL Database Server - Linux

Unit IX: Setting Up a MySQL Database Server - Linux

MySQL is a popular structured query language (SQL) database server. Like other SQL servers, MySQL provides the means of accessing and managing SQL databases. However, MySQL also provides tools for creating database structures, as well as for adding, modifying, and removing data from those structures.

Setting Up a MySQL Database Server - Linux

In this “Setting Up a MySQL Database Server - Linux” you will learn about following topics:

  1. Overview of MySQL Database Server
  2. Finding MySQL Packages
  3. Configuring the MySQL Server
  4. Using Mysql User/Group Accounts
  5. Adding Administrative Users
  6. Setting MySQL Options
  7. Starting the MySQL Server
  8. Checking That MySQL Server Is Working
  9. Working with MySQL Database
  10. Starting The Mysql Command
  11. Creating a database with mysql
  12. Adding Data To A Mysql Database Table
  13. Understanding MySQL Tables
  14. Displaying MySQL Database
  15. Displaying All or Selected Records
  16. Displaying Selected Columns
  17. Sorting Data
  18. Making Changes to Tables and Records
  19. Altering MySQL tables
  20. Updating and Deleting MySQL Records
  21. Adding and Removing User Access
  22. Adding Users And Granting Access
  23. Revoking Access
  24. Checking and Fixing Databases

========== Point to Note ==========

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at bcanotespu@gmail.com.

See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students to excel.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 7th Semester Linux Operating System Notes Pdf:

Unit I: Introduction Of Linux - Linux

Unit II: Basics Of Linux - Linux

Unit III: Installation Of Linux - Linux

Unit IV: System Administration - Linux

Unit V: User Management - Linux

Unit VI: Security And System Handling - Linux

Unit VII: Setting Up A Web Server - Linux

Unit VIII: Setting Up DHCP And NIS - Linux

Unit X: Setting Up DNS Servers - Linux

Unit XI: ISP Simulation - Linux

Hello, I am a BCA graduate. I have good knowledge of Blogger, WordPress, SEO, Content Writing, and Photo Editing. I also have expertise in Article Rewriting, Proofreading, Report Writing, Report Formatting on Microsoft Word, and other pdf files. If anyone needs help regarding these topics they can contact me.