These tutorials are copied by people, that don't know what they are doing, from tutorials that may work for other distibutions or used to work for MySQL on Debian Jessie or earlier versions. commands/ to read about creating users and granting privileges.Īvoid tutorials, that advise to run mysql_secure_installation on a MariaDB database, installed on Debian/Raspbian Stretch. n-plugins/ to read about authentication plugins. You can change that, but you breaks things, if you do so.įirst read /usr/share/doc/mariadb-server/, to figure out, what is going on with the root account. This is the way, the Debian package builders configure MariaDB. ![]() No password is used for authentication of user root. Is the way to login as root to MariaDB when you are using Raspbian Stretch. # fastcgi_pass unix:/var/run/php5-fpm.sock įastcgi_pass unix:/var/run/php/ > sudo nano /etc/nginx/sites-enabled/default Goto the host's webpage and don't worry if you see the Apache default index page > sudo apt-get install php7.0 libapache2-mod-php7.0 > sudo apt-get install mariadb-server mariadb-client > sudo apt-get update & sudo apt-get upgrade Remove the 'skip-grant-tables' parameter we added earlier.ĭO NOT Leave this parameter in the ini file its a HUGH security hole.> unzip -p -raspbian-stretch.zip | sudo dd of=/dev/sdX bs=4M conv=fsyncĬopy wpa_supplicant and ssh files to boot folder. Now enter 'quit' at the mysql command promt to exist mysql.ġ0. ![]() Note that the update should report that it has updated more than one row, that because there are actually 3 user accounts with the userid of 'root' each with a different domain i.e. UPDATE er SET Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y', Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y', Create_tablespace_priv='Y' WHERE User='root' (Given the length of the first line, it is necessary to perform copy / paste). Reassign all privileges to root : enter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql. UPDATE er SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root' Ħb. UPDATE er SET Password=PASSWORD('MyNewPass') WHERE user='root' Now we are going to reset the password for the root user, of course this could be used to reset any users password.Įnter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql. Wampmanager -> MySQL -> Service -> Start/Resume ServiceĦa. ![]() Find the or section in the ini fileĪdd this line directly after the section or Wampmanager -> MySQL -> Service -> Stop Serviceģ. The Windows session must be administrator and Wampserver started as administrator. If you have set a password for the root user, but you have forgotten it, or you accidentally deleted all with root privileges, you can choose a new password and re-allocate privileges the following procedure in Windows: Yhis is because for MySQL version since 5.7.0 the column name is changed. ERROR 1504 (42S22) : Unknown column 'password' in the 'field list'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |