PhpMyAdmin allows you to perform several database operations including, create, copy, rename, alter and drop databases, perform table maintenance, add, edit and drop fields, browse through databases and tables, export data to SQL, CSV, XML, Word, Excel, PDF and LaTeX formats, manage MySQL users and privileges, execute any SQL-statement and many more. It is designed for those who can not interact with MySQL through a command-line interface. It is written in PHP and supports 72+ languages. Import the sample: # mysql -u root -p Grant USAGE ON mysql.* TO SELECT ON mysql.db TO SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv) ON er TO SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO configured nginx by adding the following to /etc/nginx/sites-available/default as per location /phpmyadmin /phpmyadmin/examples Grant all privileges on phpmyadmin.* to identified by "redacted" I have now performed the following steps (file locations differed from suggested) cd /usr/share/phpmyadmin/sql/ Would manually creating database phpmyadmin help?īased on the answer by this seemed to be a known problem with Debian (I thought Debian packages were meant to be checked). So no phpmyadmin database seems to have been created. Mysql Ver 15.1 Distrib 10.1.23-MariaDB, for debian-linux-gnueabihf (armv7l) using readline 5.2 There seems to be no option to enter the password for have tried to interrogate MariaDB which shows:- MariaDB > status I attempted to install phpmyadmin ( sudo apt install phpmyadmin), but this keeps failing with error ERROR 1045 (28000): Access denied for user (using password: NO) I have done some WordPress configuration, and wanted to backup my WordPress GRANT ALL PRIVILEGES ON wordpress.* TO IDENTIFIED BY 'redacted' I setup MariaDB and set up WordPress Database with sudo mysql_secure_installation
In the process I ran the following sudo apt install mysql-server I have installed nginx on Raspberry Pi running Raspbian Stretch and installed Wordpress
0 kommentar(er)
