Use ODBC interface to access MySQL

The following articles mainly introduce how to correctly use the ODBC interface to access the actual operations of MySQL. Generally, all users use MySQL (the best combination of PHP and MySQL) through command lines. Many users have been using graphical user interface GUI in Windows to operate and manage databases.

Many new users may feel that the interface access to MySQL (the best combination with PHP) is not easy to master. To facilitate the management of MySQL (the best combination of PHP and MySQL) databases, some graphical user management projects are already in progress, they are MySQL (the best combination with PHP) Control CenterMySQL (the best combination with PHP) CC), MySQL (the best combination with PHP) GUI and phpMyAdmin.

In addition, you can use the OpenOffice provided by Red Hat to perform graphical Management of MySQL (the best combination with PHP. Y

Install MySQL (the best combination with PHP)

Before installing, setting, and applying graphical management tools, you must first install the MySQL (best combination with PHP) server. Run the following command to check whether MySQL is installed on the local machine (the best combination of MySQL and PHP ):

 
 

  
  
# Rpm-qa | grep MySQL (the best combination with PHP)
  
  
MySQL (best combination with PHP)-server-3.23.54a-11
  
  
MySQL (best combination with PHP)-3.23.54a-11
 
 

All examples in this article are implemented in Red Hat 9.0. In Red Hat 9.0, you can install MySQL directly through the "software package management" program (the best combination with PHP ). The specific method is to first select "SQL database server" on the "add or delete software package" interface, and select "interface access MySQL (the best combination with PHP) in the details) -server-MySQL (the best combination with PHP) server and related files ", insert the second disc, and select update.

You can also install it by running the rpm command directly from the CD.

Because MySQL (the best combination with PHP) servers require support from the Perl language to run normally, install MySQL (the best combination with PHP) when using the next installation method) install the Perl language and related software packages.

After the installation is complete, run the following command to start the MySQL (best combination with PHP) server:

 
 

  
  
# Service MySQL (the best combination with PHP) d start
 
 

After the installation of MySQL (the best combination with PHP), a Super User root is predefined and the password is blank. Any user can use this user locally from the MySQL (best combination with PHP) server to connect to the MySQL (best combination with PHP) Database for operations. Obviously this is very insecure, so after MySQL (the best combination with PHP) is started, you should set the root password immediately. The setting method is as follows:

 
 

  
  
# MySQL (the best combination with PHP) admin password 'ylgu'
 
 

In this way, a new password: ylgui is set.

Is the MySQL (best combination with PHP) server running normally? You can view it by enabling the client program MySQL (the best combination with PHP. Use the above password:

 
 

  
  
# MySQL (best combination with PHP)-u root-pylgui
  
  
Welcome to the MySQL (the best combination with PHP) monitor. Commands end with; or \ g.
  
  
Your MySQL (best combination with PHP) connection id is 6 to server version: 3.23.54
  
  
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
 
 

Note that there is no space between parameter p and password. The screen displays the databases currently available:

 
 

  
  
MySQL (best combination with PHP)> show databases; + ---------- + |
Database | + ---------- + | MySQL (the best combination with PHP) |
Test | + ---------- + 2 rows in set (0.01 sec)
 
 
 

We can see that there are two databases in the MySQL (the best combination with PHP) database server, which are the best combination of interfaces to access MySQL (and PHP) and test. This indicates that the database server has been correctly installed and started properly.