Differences

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

--- en:lamp [2016/12/20 13:29] – [Web location] Domperss
+++ en:lamp [2021/12/03 18:19] (current) – external edit 127.0.0.1
@@ Line 169: / Line 169: @@
 === 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 184: / 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;