Differences

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

--- en:lamp [2016/12/20 13:19] – [Proxy] Domperss
+++ en:lamp [2021/12/03 18:19] (current) – external edit 127.0.0.1
@@ Line 129: / Line 129: @@
    Service apache2 restart
-Your etherpad should be accessible at the right address!
+Your etherpad should now be accessible at the right address!
 ===== Mysql =====
 ==== Phpmyadmin ====
 === Installation ===
-Phpmyadmin is considered a potential security breach and would be better off. At the same time, going without database would be ideal ...
+Phpmyadmin is considered as a program with high potential security breaches.. and you would be better off without it. But at the same time, going without a database would be ideal...
+In short, despite these considerations, phpmyadmin is a handy way to manage a database when you have little knowledge, because it helps you do the job well. So... we'll try to install it.
+**OBS: MySQL Workbench would be a better solution,  "all in all"!!**
-In short, despite these considerations, phpmyadmin is a handy way to manage a database when you have little knowledge, because it helps the job well. So ... we'll try to install it.
    Sudo apt-get install phpmyadmin
-Select "apache" in the options, then for the database, let it do it.
+Select "apache" in the options, then for the database, let the process complete.
 <code> Please enter the password for the administrative account that will be used to create the MySQL database as well as the users.
@@ Line 146: / Line 149: @@
 This is the root password.
-Choose the password of the database ... and do not forget to pass it in a secured way to the other admins.
+Choose the database password... and do not forget to pass it in a "secure way" to the other admins.
 === 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 160: / 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 179: / 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;