▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 How to install phpmyadmin under Linux by UndercOde ?
T.me/UndercOdeTesting

🦑 𝕃𝔼𝕋𝕊 𝕊𝕋𝔸ℝ𝕋 :

> When installing fedora, choose the basic components that should be selected, including Appache, mysql, and php, but when we manage the database, there is still a graphical interface more convenient, so we install phpmyadmin The installation is very simple.

> phpMyAdmin is a MySQL management tool that manages MySQL directly from the web.

> Assuming your web (web hosting) root directory is / var / www / Assuming your host web access is like this http://192.168.1.11/

> You can install it to / var / www / phpmyadmin, or any subdirectory of / var / www /

> Note that this directory name is best known only by the administrator. Therefore we assume / var / www / onlyyouknow

A) First download the latest phpMyAdmin program from the official website of phpMyAdmin

http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Download phpMyAdmin-2.11.3-all-languages.tar.bz2 to / var / www /

#cd / var / www /

#wget http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Of course, you can also go to your own windows machine and edit it before uploading it to the web server @undercodetesting

B) Unzip this file

# tar zxvf phpMyAdmin-2.11.3-all-languages.tar.gz

At this point the path /var/www/phpMyAdmin-2.11.3-all-languages

C) Change the directory name to / var / www / onlyyoukown

# mv /var/www/phpMyAdmin-2.11.3-all-languages ​​/ var / www / onlyyoukown

D) Modify the profile

1) Find the /libraries/config.default.php file (config.default.php is copied to the phpmyadmin directory and then renamed to config.inc.php). WordPad (don't use Notepad, this is UTF8 encoding) for editing, directly use vim under Linux.

2) Find $ cfg ['PmaAbsoluteUri'] and change it to the phpMyAdmin URL you will upload to the space

For example: $ cfg ['PmaAbsoluteUri'] = 'http://192.168.1.11/onlyyouknow/';

3) Find $ cfg ['Servers'] [$ i] ['host'] = 'localhost'; (usually use the default, there are exceptions, you don't need to modify)

4) Find $ cfg ['Servers'] [$ i] ['auth_type'] = 'config';

Debug in your own machine with config; if you use cookies in the space on the network, since we have already added the URL here, we will modify them to cookies. We recommend using cookies here.

5) Find $ cfg ['Servers'] [$ i] ['user'] = 'root'; // MySQL user (mysql user name, use root on your machine;)

6) Find $ cfg ['Servers'] [$ i] ['password'] = ''; // MySQL password (the password of the mysql user, your own server is usually the password of the mysql user root)

7) Find $ cfg ['Servers'] [$ i] ['only_db'] = ''; // If set to a db-name, only (If you have only one data, set it; if you are on the machine or want to Setting up the server, then it is recommended to leave it blank)

8) Find $ cfg ['DefaultLang'] = 'zh'; (Here is the choice of language, zh stands for Simplified Chinese, I do n’t know if I fill in gbk here)

9) Save after setting

If "Configuration file now requires top secret phrase password (blowfish_secret)" then please set your website cookie in the equal sign of $ cfg ['blowfish_secret'] = ''; For example: $ cfg ['blowfish_secret'] = ' Arbitrary character '; this is because of your "$ cfg [' Servers'] [$ i] ['auth_type'] = 'cookie'.

E) Testing

Open your browser, http://192.168.1.11/onlyyoukown/

🦑 A little personal opinion

We don't think that controlling mysql by the root user of mysql from the web is not a very safe way. So my suggestion is that if it is your own server, you can put the phpadmin directory into a directory that the web cannot access when you run out. Use the mv command to move the entire directory back to the original location.

Written by Undercode
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 How to install phpmyadmin under Linux?

1) When installing fedora, select the basic components that should be selected, including Appache, mysql, and php, but when we manage the database, it is still more convenient to have a graphical interface, so we install phpmyadmin ourselves , The installation is very simple.

2) phpMyAdmin is a MySQL management tool that manages MySQL directly from the web.

3) Assuming your web (webpage storage) root directory is / var / www / assuming your host web access is like this http://192.168.1.11/

4) You can install it to / var / www / phpmyadmin or of course any subordinate directory of / var / www /

5) Note that the name of this directory is best known only to the administrator. Therefore, we assume / var / www / onlyyouknow

6)A. First go to the official website of phpMyAdmin to download the latest phpMyAdmin program

🦑 http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

1) Download phpMyAdmin-2.11.3-all-languages.tar.bz2 to / var / www /

#cd / var / www /

#wget http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Of course, you can also go to your own windows machine, and la2ter upload it to the web server after editing it

2) Unzip this file

# tar zxvf phpMyAdmin-2.11.3-all-languages.tar.gz

At this time the path /var/www/phpMyAdmin-2.11.3-all-languages

3) Change the directory name to / var / www / onlyyoukown

# mv /var/www/phpMyAdmin-2.11.3-all-languages / var / www / onlyyoukown

🦑D. Modify the configuration file

1) Find the /libraries/config.default.php file (copy config.default.php to the phpmyadmin directory, and then rename it to config.inc.php), the file has the following items (2-8) must be configured by yourself Wordpad (do not use Notepad, this is UTF8 encoding) for editing, directly edit with vim under linux.

2) Find $ cfg ['PmaAbsoluteUri'] and change it to the phpMyAdmin URL that you will upload to the space

For example: $ cfg ['PmaAbsoluteUri'] = 'http://192.168.1.11/onlyyouknow/';

3) Find $ cfg ['Servers'] [$ i] ['host'] = 'localhost'; (usually use the default, there are exceptions, you can not modify)

4) Find $ cfg ['Servers'] [$ i] ['auth_type'] = 'config';

Use config for debugging in your own machine; if you use cookies in the space on the network, since we have added the URL in the front, we will modify it to a cookie. Here we recommend using cookies.

5) Find $ cfg ['Servers'] [$ i] ['user'] = 'root'; // MySQL user (mysql user name, use root in your machine;)

6) Find $ cfg ['Servers'] [$ i] ['password'] = ''; // MySQL password (mysql user's password, his server is generally the password of the mysql user root)

7) Find $ cfg ['Servers'] [$ i] ['only_db'] = ''; // If set to a db-name, only (set it if you only have one data; if you are on this machine or want to Set up the server, it is recommended to leave it blank)

8) Find $ cfg ['DefaultLang'] = 'zh'; (Here is the choice of language, zh stands for Simplified Chinese, I do n’t know whether to fill in gbk or not)

9) Save after setting

If "The configuration file now requires the top secret phrase password (blowfish_secret)", please set the cookie of your website in the equal sign of $ cfg ['blowfish_secret'] = ''; for example: $ cfg ['blowfish_secret'] = ' Any character '; This is because of your "$ cfg [' Servers'] [$ i] ['auth_type'] = 'cookie'.

🦑 Test

1) Open the browser, http://192.168.1.11/onlyyoukown/

A little personal opinion

2) We think that it is not a very safe way to control mysql through the root user of mysql from the web. So my suggestion is that if it is your own server, you can put the phpadmin directory into a directory that the web cannot access when you run out. Use it to move the entire directory back to its original location with the mv command.

WRITTEN BY UNDERCODE
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 How to install phpmyadmin under Linux? BY UNDERCODE


1) When installing fedora, select the basic components that should be selected, including Appache, mysql, and php, but when we manage the database, it is still more convenient to have a graphical interface, so we install phpmyadmin ourselves , The installation is very simple.

2) phpMyAdmin is a MySQL management tool that manages MySQL directly from the web.

3) Assuming your web (webpage storage) root directory is / var / www / assuming your host web access is like this http://192.168.1.11/

4) You can install it to / var / www / phpmyadmin or of course any subordinate directory of / var / www /

Note that the name of this directory is best known only to the administrator. Therefore, we assume / var / www / onlyyouknow

A. First go to the official website of phpMyAdmin to download the latest phpMyAdmin program

http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Download phpMyAdmin-2.11.3-all-languages.tar.bz2 to / var / www /

#cd / var / www /

#wget http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Of course, you can also go to your own windows machine, and later upload it to the web server after editing it

B. Unzip this file

# tar zxvf phpMyAdmin-2.11.3-all-languages.tar.gz

At this time the path /var/www/phpMyAdmin-2.11.3-all-languages

C. Change the directory name to / var / www / onlyyoukown

# mv /var/www/phpMyAdmin-2.11.3-all-languages / var / www / onlyyoukown

D. Modify the configuration file

1. Find the /libraries/config.default.php file (copy config.default.php to the phpmyadmin directory, and then rename it to config.inc.php), the file has the following items (2-8) must be configured by yourself Wordpad (do not use Notepad, this is UTF8 encoding) for editing, directly edit with vim under linux.

2. Find $ cfg ['PmaAbsoluteUri'] and change it to the phpMyAdmin URL that you will upload to the space

For example: $ cfg ['PmaAbsoluteUri'] = 'http://192.168.1.11/onlyyouknow/';

3. Find $ cfg ['Servers'] [$ i] ['host'] = 'localhost'; (usually use the default, there are exceptions, you can not modify)

4. Find $ cfg ['Servers'] [$ i] ['auth_type'] = 'config';

Use config for debugging in your own machine; if you use cookies in the space on the network, since we have added the URL in the front, we will modify it to a cookie. Here we recommend using cookies.

5. Find $ cfg ['Servers'] [$ i] ['user'] = 'root'; // MySQL user (mysql user name, use root in your machine;)

6. Find $ cfg ['Servers'] [$ i] ['password'] = ''; // MySQL password (mysql user's password, his server is generally the password of the mysql user root)

7. Find $ cfg ['Servers'] [$ i] ['only_db'] = ''; // If set to a db-name, only (set it if you only have one data; if you are on this machine Set up the server, it is recommended to leave it blank)

8. Find $ cfg ['DefaultLang'] = 'zh'; (Here is the choice of language, zh stands for Simplified Chinese, I do n’t know whether to fill in gbk or not)

9. Save after setting

If “The configuration file now requires the top secret phrase password (blowfish_secret)”, then please set the cookie of your website in the equal sign of $ cfg ['blowfish_secret'] = ''; Any character '; This is because of your "$ cfg [' Servers'] [$ i] ['auth_type'] = 'cookie'.

E. Test

Open the browser, http://192.168.1.11/onlyyoukown/

A little personal opinion

We think that it is not a very safe way to control mysql through the root user of mysql from the web. So my suggestion is that if it is your own server, you can put the phpadmin directory into a directory that the web cannot access when you run out. Use it to move the entire directory back to its original location with the mv command.

Written by Undercode
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁