MySQL Control (Web hosting reseller) Center featuresAfter you install the MySQL

MySQL Control Center featuresAfter you install the MySQL Control Center, you reready to take advantage of its handy tools. Here show to get to them: 1.Start the Control Center with the followingcommand: #./mysqlccThe MySQLCC window and the Register Serverdialog both open (see Figure 43-3). Figure 43-3:MySQLCC s opening view. 2.On the General tab of the Register Server dia- log, enter the name of the computer in the HostName field. If you have multiple MySQL servers running(scattered around your network), you maywant to enter a server name that s meaningfulto you in the Name field to make the differentservers easy to distinguish. 3.Click Add to display the session propertiesneatly in the Console Manager (see Figure 43-4). Figure 43-4: The Console Manager. 4.Double-click a server name in the MySQLServers frame to expand the tree control anddisplay the controls for Databases, ServerAdministration, and User Administration. 5.Highlight any entry in the Server tree control(Databases, Server Administration, or UserAdministration) to display status informationabout that aspect of the MySQL server. The following sections have more details on eachof these controls. Viewing, managing, and repairing a databasewith the Databases controlsThe Databases controls enable you to view yourdatabase, and you also have tools for managing dataand fixing problems as well. MySQLCC is a complete MySQL client application. You can use MySQLCC to execute SQL commandsand queries, but it s really designed to give youaquick overview of the state of your database. Toview the statistics for databases, follow thesesteps:
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.

Leave a Reply