MySQL + Webmin easily create databases

Use on LinuxMySQL, Can be easilyCreate a database, Used in LinuxWebminIt is very easy to create a MySQL database through a graphical interface. The following describes how to create a database in combination with MySQL and Webmin.

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.

Create a table

First, click the Create New Database link on the home page of the MySQL Database server. If you want to, graph A on the New Database Options page will let you fill in some details and create an initial table in the Database. Next we use the initial table named Editorial to create a database named LinuxUsers. We will proceed step by step .) If you do not want to use an initial Table to Create the database, you only need to enter the required database name.) Select the None radio button next to the nitial Table and click Create.

Figure A: Unfortunately, the initial table created in your new database only contains four fields.

In this example, an initial table is created. Name the four fields in the table as UserName, Extension, OfficeNumber, and MachineName. Once you fill in the information, and click Create; you will return to the MySQL database server home page, and you can see the newly created database icon, B.

Figure B: Click LinuxUsers to view the Editorial icon of the initial table.

During the creation of the initial table, you should note that you cannot define any entry as the initial key. Click the Editorial icon, and you will see the list of the four portals we created in Figure C.

Figure C: If you see Yes for all Allow Nulls entries, you have not set any initial Jian.

Let's set UserName as the initial key. In general, there is always an entry for this domain. Click the UserName entry in the Field Name column to go to the Field Parameters page. Graphics D)

Graph D: if a specific domain uses a public portal, you need to give it a default value.

Select No for Allow Nulls and Yes for Part Of Primary Key. You can also set a default value for the initial health. We do not want to give the domain UserName a default value, but we can do the same. After the two values change, click Save and return to the Edit Table Page. You will see No in the Allow Nulls column and Primary graph C in the main column ).

The next table we want to create is a copy of Editorial, named Webdev. On the home page of the MySQL Database server, click the Database you want to Edit. The Edit Database page is displayed. Click Create New Table. Enter Webdev in the Table Name field, select LinuxUsersEditorial in the Copy Fields From Table list, and click Create. You will return to the Edit Database interface and see the new Database table.