MySQL Configuration

In this lesson you will read about the configuration of MySQL . The MySQL server configuration normally started during installation process .

MySQL Configuration

MySQL Configuration

     

In this lesson you will read about the configuration of MySQL . The MySQL server configuration normally started during  installation process . 

MySQL server configuration wizard window 

The MySQL configuration wizard can be launched by clicking the MySQL server instance configuration wizard entry in the MySQL section of the window start menu. Another way to launch the configuration wizard, you can  launch the MySQLInstanceConfig.exe file directly from bin directory of your MySQL installation. The MySQL server configuration wizard sets configuration variables values in my.ini file in the installation directory for the MySQL server. 

--defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

Path "C:\Program Files\MySQL\MySQL Server 5.0" is  installation directory of MySQL server . The --defaults-file option instructs the MySQL server to read the specified file for configuration options when it starts. 
The MySQL client and utilities like mysql and mysqldump command-line client are unable to locate the my.ini file locate in the server installation directory. The MySQL use window server 2003, window server 2000 and window XP, MySQL server configuration wizard will configure MySQL to work as a windows services.

The MySQL Server configuration wizard on Linux
If you want to install the MySQL server configuration on Linux then you have to run the mysqlsetup command. For displaying MySQL server configuration wizard interface on a different machine, then you have to set the value of the DISPLAY variable on the command line. 

Example

shell>
DISPLAY=remote:0.0 mysqlsetup 

MySQL choosing Installation type
When you start the MySQL server configuration wizard for a new MySQL installation then choose the re-configure instance option. There are two type of MySQL configuration wizard installation:-

  • Detailed Configuration
    The MySQL Detailed configuration option is intended for advanced users who want more fine-grained control over server configuration. 
     
  • Standard Configuration 
    The MySQL Standard configuration option is intended for new users who want to get started with MySQL quickly without having to make many decisions about server configuration.

Tutorials

  1. MySQL Column Type Database
  2. MySQL Training ? Online Free MySQL Training
  3. Introduction to MySQL
  4. What is MySQL
  5. Installing MySQL on Windows
  6. MySQL Configuration
  7. MySQL Creating account and changing password
  8. Understanding Various MySQL Executable Files
  9. MySQL User Interface
  10. MySQL Monitoring
  11. MySQL Creating and Deleting Database
  12. Database Designing
  13. Identifiers & Qualifiers
  14. Operators & Functions
  15. MySQL Select Statement
  16. Selecting All Columns or Specific columns
  17. Data Definition Statement
  18. Data Manipulation Statements
  19. Joins
  20. Views
  21. Stored Procedures and Functions
  22. Writing Subqueries
  23. Flow Control Constructs
  24. CURSORS
  25. TRIGGERS
  26. Locking Issues
  27. MySQL Transactional and Locking Statements
  28. Table Maintenance Statements
  29. SET Syntax
  30. Account Management Statements
  31. MySQL String Function
  32. MySQL Training ? Online Free MySQL Training
  33. Identifiers & Qualifiers
  34. Identifiers & Qualifiers
  35. The info Attribute of page Directive In JSP
  36. MySQL Configuration
  37. Creating Database Tables and Indexes
  38. MySQL Directory Structure
  39. MySQL How to Topic
  40. Identifiers Qualifiers