Learn how to create a MySQL + Webmin database in Linux

How many times have you been embarrassed to consider how to set up a database? In fact, if you use MySQL on Linux, this will not happen. Using the Webmin GUI on Linux to create a MySQL database is quite simple.

In this article, we will take a look at some basic functions in MySQL database applications. However, instead of listing all commands mechanically, you will use your own methods to quickly create MySQL Databases and database tables and add data to these tables. This article assumes that you have installed MySQL on your Linux host.

New Webmin

Webmin is a Web-based Linux management tool that allows you to specify a browser on port 10000 and manage your Linux box. With this tool, you can manage Apache, Samba, MySQL, Postfix, ftp, ppp, and so on. There are too many items that can't be completed.

These are all very simple. download the latest version from the fpmfind site and install it. Run with the correct rpm command (with root privileges), for example: rpm-ivh webmin-0.87.rpm

Or install the correct command set from the resource (with the root permission ):

Tar xvzf webmin-o.8.7.tar.gz

Cd webmin-0.87

./Setup. sh

Then, after the application is installed, answer all the questions to ensure that your Web server runs correctly. (In most systems, you can run the httpd background program with the root permission:/etc/rc. d/init. d/HTTPD start .) Direct your browser to http: // localhost: 10000 and use the Administrator name and password in the installation configuration.

Once you log on to Webmin, you can click the Servers tab and click the MySQL Database Server icon (this is the purpose of this Article ). If your MySQL database Server is not running, you will see the Start MySQL Server button. To enter the MySQL database server page, you must start the server, so click this button. Once you log on to the MySQL database server page, you can add and edit your MySQL table.

Overall Configuration

At the bottom of the MySQL Database server page, you will see a row of icons for setting the overall permissions: User Permission, Database Permission, Host Permission, Table Permission, and Field Permission. Each entry can be self-explanatory. The only thing that may make you confused is that you can select All the permissions, but there is no All option for you to choose from. If you want to provide full permission for a user, database, host, table, or domain, you can select all the options in the list and Save the settings by pressing Save; in this way, the domain has permissions on other items.

1 2 Next Page

[Content navigation]
Page 1st: Learn How to Create a MySQL + Webmin database in Linux	Page 1: Create a table