Reading table information for completion of table and column names Step 5 : change the database to phpmyadmin by using the below command MariaDB > use phpmyadmin Step 4 : List the databases by using the below command MariaDB > show databases Type '\c' to clear the current input statement. Step 3 : Login into mysql database root by using the below command :~# mysql -u root -p Processing triggers for hicolor-icon-theme (0.17-2). Processing triggers for doc-base (0.10.9). Verifying database phpmyadmin exists: success.ĭbconfig-common: flushing administrative passwordĪpache2_invoke: Enable configuration phpmyadmin Verifying access for : success.ĭbconfig-common: dumping mysql database phpmyadmin to /var/tmp/phpmyadmin.phpmyadmin.-06.02.mysql.tIRD5h.ĭbconfig-common: dropping old mysql database phpmyadmin.ĭropping database phpmyadmin: database does not exist. Granting access to database phpmyadmin for : success. ĭbconfig-common: writing config to /etc/dbconfig-common/nfĬhecking privileges on database phpmyadmin for : user creation needed. 283109 files and directories currently installed.) Selecting previously unselected package phpmyadmin. Get:1 focal/universe amd64 phpmyadmin all 4:4.9.5 dfsg1-2 ĭetermining localhost credentials from /etc/mysql/debian.cnf: succeeded. The following NEW packages will be installed:Ġ upgraded, 1 newly installed, 0 to remove and 16 not upgraded.Īfter this operation, 27.2 MB of additional disk space will be used. Php-recode php-gd2 php-pragmarx-google2fa php-bacon-qr-code php-samyoul-u2f-php-server Step 2 : Install the phpmyadmin by using the below command :~# apt install phpmyadmin -y Step 1 : Check the OS version by using the below command :~# lsb_release -a As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services. PhpMyAdmin is a free and open source administration tool for MySQL and MariaDB. The following permissions are recommended for compatibility with most modern web-based software applications.To Install PhpMyAdmin On Linux Mint 20.2 Introduction : Choose the database you want the user to be able to access from the list, and click GO.Īssign the permissions as shown to provide the user with access to the given database. Scroll down to the section titled Database-Specific Privileges. Once again leave the Global Privileges section BLANK. Click Edit Privileges to assign access to a specific database. Therefore leave this section BLANK, and then click the Add User button.Īfter the user is created, you can see it listed on the Users page. It is far more secure to assign seperate user logins to each piece of software or website that will require access to only a particular database. It is recommended that you do NOT assign these permissions unless you know exactly what you are doing. The section that relates to the users GLOBAL privileges are privileges you want to assign to this user which apply to ALL databases on the server. Optionally you can press the Generate button to create a random password for you. In the section titled Login Information - type in a username, localhost and a password in the fields as shown. Choose the Add User option under the list of available server users. To setup a new user login to access this database, click on Users in the main menu. ![]() ![]() ![]() Your database will now be visible on the right hand side under the list of available databases. Leave the collation drop down box if you wish to use the default MySQL schema collation. In the create database field type in a name for your database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |