| Alter_routine_priv | enum('N','Y') | NO | | N | | | Create_routine_priv | enum('N','Y') | NO | | N | | | Create_tmp_table_priv | enum('N','Y') | NO | | N | | | References_priv | enum('N','Y') | NO | | N | | | Field | Type | Null | Key | Default | Extra | Mysql> update user set password=PASSWORD("password") where User='root' ĮRROR 1054 (42S22): Unknown column 'password' in 'field list' You can turn off this feature to get a quicker startup with -A Reading table information for completion of table and column names
Then in mysql, i try to change the password but it doesn't recognise the field name: I do a desc to see what is in there: mysql> use mysql
#Install mysql ubuntu 20.10 how to
Is the problem that I'm not using the right password, or is it something more fundamental? If it's the password, how to I find out what it is/reset it? Thanks, MaxĮDIT: Following f35's answer below, i did the following: sudo service mysql stop I just hit enter for each, which I thought was like saying "No password".īut now, I thought i'd be able to get into it with mysql -u root, but it says ERROR 1698 (28000): Access denied for user tried a reboot just in case. Which has installed mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrappeĪnd this went through a few "gui" screens prompting me for passwords.
#Install mysql ubuntu 20.10 install
I did this as follows: sudo apt-get install mysql-server I've just installed a new Linux Mint 18 MATE, and am trying to install Mysql.
I used the top answer from that page and it worked. EDIT: I believe this is actually a duplicate of
0 kommentar(er)
