When it comes to configuring the MySQL service, it is best to allow professionals to change the name and location of the config file (where the startup parameters are stored) or to activate support for BDB. It is possible to start and stop the service with the click of a mouse, with the users receiving the warning that all connected users also get disconnected. The Server Information section is the place where users can get details about the server status, the MySQL version running on the server, network name and IP, as well as client data like hardware, IP and OS. The main window is neatly organized and each function can be accessed from the left panel. Each of these utilities has their own specific role so it is best to experiment with each of them before relying on them in production environments.īefore being able to access the interface of MySQL Administrator, a database connection needs to be established (the server host, username and password need to be entered). When installing this package, users get several tools: MySQL Administrator, MySQL Migration Toolkit, MySQL Query Browser and MySQL System Tray Monitor. While experts can typically perform most tasks they need from command-line, a graphical user interface tool is ideal for database newbies – this is where MySQL Administrator comes in handy. MySQL is a popular relational database management system and it is meant to offer multi-user access to various databases by acting like a server.
0 Comments
Leave a Reply. |