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.
In this “Setting Up a MySQL Database Server - Linux” you will learn about following topics:
- Overview of MySQL Database Server
- Finding MySQL Packages
- Configuring the MySQL Server
- Using Mysql User/Group Accounts
- Adding Administrative Users
- Setting MySQL Options
- Starting the MySQL Server
- Checking That MySQL Server Is Working
- Working with MySQL Database
- Starting The Mysql Command
- Creating a database with mysql
- Adding Data To A Mysql Database Table
- Understanding MySQL Tables
- Displaying MySQL Database
- Displaying All or Selected Records
- Displaying Selected Columns
- Sorting Data
- Making Changes to Tables and Records
- Altering MySQL tables
- Updating and Deleting MySQL Records
- Adding and Removing User Access
- Adding Users And Granting Access
- Revoking Access
- 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 [email protected].
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
- Unit II: Basics Of Linux
- Unit III: Installation Of Linux
- Unit IV: System Administration
- Unit V: User Management
- Unit VI: Security And System Handling
- Unit VII: Setting Up A Web Server
- Unit VIII: Setting Up DHCP And NIS
- Unit X: Setting up DNS Servers
- Unit XI: ISP Simulation
0 Comments