LAMP
Setting up mysql-server-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Setting up perl-modules (5.18.2-2ubuntu1.7) ...
Setting up perl (5.18.2-2ubuntu1.7) ...
Setting up libdbi-perl (1.630-1) ...
Setting up libdbd-mysql-perl (4.025-1ubuntu0.1) ...
Setting up libterm-readkey-perl (2.31-1) ...
Setting up mysql-client-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Setting up mysql-server-5.5 (5.5.62-0ubuntu0.14.04.1) ...
190207 10:21:56 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
190207 10:21:56 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190207 10:21:56 [Note] /usr/sbin/mysqld (mysqld 5.5.62-0ubuntu0.14.04.1) starting as process 9416 ...
mysql start/running, process 9547
Processing triggers for ureadahead (0.100.0-16) ...
Setting up mysql-server (5.5.62-0ubuntu0.14.04.1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
Kalle-Kassler-PC ~ # sudo mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] n
... skipping.
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] n
... skipping.
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] n
... skipping.
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Kalle-Kassler-PC ~ # sudo mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Kalle-Kassler-PC ~ # exit
exit
kalle@Kalle-Kassler-PC ~ $ sudo mysql
[sudo] password for kalle:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
kalle@Kalle-Kassler-PC ~ $ sudo mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
kalle@Kalle-Kassler-PC ~ $ sudo -s
Kalle-Kassler-PC ~ # sudo mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] y
New password:
Re-enter new password:
Sorry, you can't use an empty password here.
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n]
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n]
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n]
- Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
... Failed! Not critical, keep moving...
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n]
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Kalle-Kassler-PC ~ # sudo mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Kalle-Kassler-PC ~ # sudo apt remove mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libterm-readkey-perl
mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
mysql-server-core-5.5
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
mysql-server
0 upgraded, 0 newly installed, 1 to remove and 546 not upgraded.
After this operation, 125 kB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 163263 files and directories currently installed.)
Removing mysql-server (5.5.62-0ubuntu0.14.04.1) ...
Kalle-Kassler-PC ~ # sudo apt
autoclean contains held reinstall update
autoremove content help remove upgrade
build deb hold search version
build-dep depends install show
changelog dist-upgrade policy source
check download purge sources
clean dselect-upgrade rdepends unhold
Kalle-Kassler-PC ~ # sudo apt autoclean
Reading package lists... Done
Building dependency tree
Reading state information... Done
Del openssh-server 1:6.6p1-2ubuntu2.8 [326 kB]
Del thunderbird-locale-en-us 1:45.2.0+build1-0ubuntu0.14.
Del openssh-sftp-server 1:6.6p1-2ubuntu2.8 [35,5 kB]
Del thunderbird 1:45.2.0+build1-0ubuntu0.14.
Del chromium-browser 51.0.2704.79-0ubuntu0.14.04.1.
Del libvncserver0 0.9.9+dfsg-1ubuntu1.1 [163 kB]
Del thunderbird-gnome-support 1:45.2.0+build1-0ubuntu0.14.
Del thunderbird-locale-en 1:45.2.0+build1-0ubuntu0.14.
Del mintupdate 4.9.9.1 [120 kB]
Del openssh-client 1:6.6p1-2ubuntu2.8 [576 kB]
Del chromium-codecs-ffmpeg-extra 51.0.2704.79-0ubuntu0.14.04.1.
Kalle-Kassler-PC ~ # sudo apt autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libterm-readkey-perl
mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
mysql-server-core-5.5
0 upgraded, 0 newly installed, 9 to remove and 546 not upgraded.
After this operation, 93,9 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 163259 files and directories currently installed.)
Removing mysql-server-5.5 (5.5.62-0ubuntu0.14.04.1) ...
mysql stop/waiting
Removing mysql-client-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Removing libdbd-mysql-perl (4.025-1ubuntu0.1) ...
Removing libdbi-perl (1.630-1) ...
Removing libmysqlclient18:i386 (5.5.62-0ubuntu0.14.04.1) ...
Removing libterm-readkey-perl (2.31-1) ...
Removing mysql-client-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Removing mysql-common (5.5.62-0ubuntu0.14.04.1) ...
Removing mysql-server-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
Kalle-Kassler-PC ~ # exit
exit
kalle@Kalle-Kassler-PC ~ $ sudo apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libterm-readkey-perl
mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
mysql-server-core-5.5
Suggested packages:
libmldbm-perl libnet-daemon-perl libplrpc-perl libsql-statement-perl tinyca
mailx
Recommended packages:
libhtml-template-perl
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libterm-readkey-perl
mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 10 newly installed, 0 to remove and 546 not upgraded.
Need to get 0 B/9 391 kB of archives.
After this operation, 94,1 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 162836 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.5.62-
Unpacking mysql-common (5.5.62-0ubuntu0.14.04.1) ...
Selecting previously unselected package libmysqlclient18:i386.
Preparing to unpack .../libmysqlclient18_5.5.62-
Unpacking libmysqlclient18:i386 (5.5.62-0ubuntu0.14.04.1) ...
Selecting previously unselected package libdbi-perl.
Preparing to unpack .../libdbi-perl_1.630-1_i386.
Unpacking libdbi-perl (1.630-1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.025-
Unpacking libdbd-mysql-perl (4.025-1ubuntu0.1) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../libterm-readkey-perl_2.31-
Unpacking libterm-readkey-perl (2.31-1) ...
Selecting previously unselected package mysql-client-core-5.5.
Preparing to unpack .../mysql-client-core-5.5_5.5.
Unpacking mysql-client-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-client-5.5.
Preparing to unpack .../mysql-client-5.5_5.5.62-
Unpacking mysql-client-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-core-5.5.
Preparing to unpack .../mysql-server-core-5.5_5.5.
Unpacking mysql-server-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up mysql-common (5.5.62-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 163186 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.5_5.5.62-
Unpacking mysql-server-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.5.62-
Unpacking mysql-server (5.5.62-0ubuntu0.14.04.1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up libmysqlclient18:i386 (5.5.62-0ubuntu0.14.04.1) ...
Setting up libdbi-perl (1.630-1) ...
Setting up libdbd-mysql-perl (4.025-1ubuntu0.1) ...
Setting up libterm-readkey-perl (2.31-1) ...
Setting up mysql-client-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Setting up mysql-client-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Setting up mysql-server-core-5.5 (5.5.62-0ubuntu0.14.04.1) ...
Setting up mysql-server-5.5 (5.5.62-0ubuntu0.14.04.1) ...
mysql start/running, process 14224
Setting up mysql-server (5.5.62-0ubuntu0.14.04.1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
kalle@Kalle-Kassler-PC ~ $ sudo mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Enter current password for root (enter for none):
Aborting!
Cleaning up...
kalle@Kalle-Kassler-PC ~ $ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
kalle@Kalle-Kassler-PC ~ $ sudo mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
kalle@Kalle-Kassler-PC ~ $ sudo dpkg-reconfigure mysql-server
mysql-server mysql-server-5.5 mysql-server-core-5.5
kalle@Kalle-Kassler-PC ~ $ sudo dpkg-reconfigure mysql-server-5.5
mysql stop/waiting
190207 10:30:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
190207 10:30:48 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190207 10:30:48 [Note] /usr/sbin/mysqld (mysqld 5.5.62-0ubuntu0.14.04.1) starting as process 14625 ...
mysql start/running, process 14822
kalle@Kalle-Kassler-PC ~ $ sudo mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] n
... skipping.
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] n
... skipping.
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] n
... skipping.
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
... Failed! Not critical, keep moving...
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
kalle@Kalle-Kassler-PC ~ $ sudo mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
kalle@Kalle-Kassler-PC ~ $ sudo dpkg-reconfigure mysql-server-5.5
mysql stop/waiting
190207 10:33:14 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
190207 10:33:14 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
190207 10:33:14 [Note] /usr/sbin/mysqld (mysqld 5.5.62-0ubuntu0.14.04.1) starting as process 15163 ...
mysql start/running, process 15295
kalle@Kalle-Kassler-PC ~ $ sudo mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
... Failed! Not critical, keep moving...
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
kalle@Kalle-Kassler-PC ~ $ sudo mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
kalle@Kalle-Kassler-PC ~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.5.62-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
