Differences

This shows you the differences between two versions of the page.

--- en:lamp [2016/12/20 13:26] – [Installation] Domperss
+++ en:lamp [2021/12/03 18:19] (current) – external edit 127.0.0.1
@@ Line 153: / Line 153: @@
 === Web location ===
-By default, phpmyadmin is accessible at ''site.net/phpmyadmin'', which helps a malicious user find the door. It can be modified via the file ''/etc/apache2/conf.d/phpmyadmin.conf'', changing the default alias:
+By default, phpmyadmin is accessible at ''site.net/phpmyadmin'', which helps a malicious user find the door. It can be modified via the file ''/etc/apache2/conf.d/phpmyadmin.conf'', You can change the default alias like this:
    Alias/phpmyadmin/usr/share/phpmyadmin
 For example:
@@ Line 163: / Line 163: @@
 <WRAP center round important 60%>
 Having a login other than "root" would be as good. But can it be easily changed?
+**OBS: It's pretty bad to use ROOT as the database login. A better way is to make a user and select the rights accordingly!!**
 </WRAP>
 === Importing a database ===
-To import a database via phpmyadmin(eg forum forum, saved before), you must create the database, associate it with a user who will have access on this database only, then import the saved ".sql".
+To import a database via phpmyadmin(for ex: forum backups ), you must create the database, associate it with a user who is the only one having access to the database, then lastly import the saved ".sql".
-If the base is too large, there will be an error. Change /etc/php5/apache2/php.ini to increase the maximum size allowed. Phpmyadmin makes an error linking what needs to be changed.
+If the database is too large, there will be errors. One fix is to change /etc/php5/apache2/php.ini to increase the maximum size allowed. The phpmyadmin program makes error linking(so you can see what needs to be changed).
 ==== Various Mysql commands ====
@@ Line 182: / Line 184: @@
    Mysql> create database MyDatabase;
-) Create a user and grant him access rights to the database without a password but only locally:
+) Create a user and grant him access rights to the database without a password **but only locally**:
    Mysql> GRANT ALL ON MyDatabase. * TO User @ localhost;