Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to use Webmin to create Database in MySQL

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

How to use Webmin to create a database in MySQL, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

How does MySQL+Webmin create a database

New Webmin

Webmin is a Web-based management tool for Linux, which allows you to specify your 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 to list.

It's all simple, download the latest version from the fpmfind site and install it. Run with the correct rpm command (with root privileges), for example: rpm-ivhwebmin-0.87.rpm

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

Tarxvzfwebmin-o.8.7.tar.gz

Cdwebmin-0.87

. / setup.sh

Then, after the application is installed, answer all queries that appear to make sure your Web server is running correctly. (on most systems, you can run the HTTPD daemon by executing / etc/rc.d/init.d/httpdstart with root privileges.) Point your browser to http://localhost:10000 and operate with the administrator name and password in the installation configuration.

Once you have logged in to Webmin, you can click the Series tab and click the MySQL database server icon (which is the purpose of this article). If your MySQL database server is not running, you will see the StartMySQLServer button. If you want to go to the MySQL database server page, you must start the server, so click this button. Once you have logged in to the MySQL database server page, you can start adding and editing your MySQL tables.

Overall configuration

At the bottom of the MySQL database server page, you will see a row of icons that set the overall permissions: UserPermission,DatabasePermission,HostPermission,TablePermission,andFieldPermission. Each entrance can be explained by itself. The only thing that may confuse you is that you can select all the permits, but there is no All option for you to choose from. If you want to provide a full license for the user / database / host / table / domain, you can select all the options in the list and press Save to save the settings; so that the domain has permissions for all other items.

Create a table

First, on the main page of the MySQL database server, click the CreateNewDatabase link. If you like, the NewDatabaseOptions page (graphic A) will let you fill in some details and create an initial table in the database. Let's create a database called LinuxUsers with an initial table called Editorial. We will take it step by step.) If you don't want to create the database with an initial table, just fill in the name of the database (required), select the None radio button next to nitialTable, and then click Create.

How does MySQL+Webmin create a database

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

In this example, we will create an initial table. Name the four fields in the table: UserName,Extension,OfficeNumber, and MachineName. Once you fill in the information and click Create;, you will return to the main page of the MySQL database server and see the icon of the newly created database, such as figure B.

Figure B: click on the LinuxUsers icon and you will see the icon Editorial 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 a list of the four entries we created in the table (figure C).

Graphic C: if you see Yes for all AllowNulls entrances, then you haven't set any initial keys.

Let's set UserName to the initial key, so generally speaking, there is always an entry for this domain. Click the UserName entry under the FieldName bar to enter the FieldParameters page. (figure D)

Figure D: if a specific domain uses a common entry, you need to give it a default value.

Select No for AllowNulls and Yes for PartOfPrimaryKey. You can also give the initial key a default value. We don't want to give the domain UserName a default, but we can do that, too. After these two values have changed, click Save and go back to the EditTable page. You will see No in the AllowNulls bar and Primary (figure C) in the main column.

The next table you are going to create is a copy of Editorial called Webdev. On the main page of the MySQL database server, click on the database you want to edit, and the EditDatabase interface will appear. Click the CreateNewTable button. Fill in Webdev in the name of the form, select LinuxUsersEditorial in the CopyFieldsFromTable list, and click create. You will go back to the EditDatabase interface and see the new database table.

This is the answer to the question about how to use Webmin to create a database in MySQL. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report