[Klug-general] Round and round, like a windmill in the sky!

Fri Oct 18 12:52:19 UTC 2013

On Fri, 18 Oct 2013 12:44:47 +0100
Alan <alan at hipnosi.org> wrote:

> On 18/10/13 12:09, Sharon Kimble wrote:
> > On Fri, 18 Oct 2013 11:59:26 +0100
> > Evan Ingram <evan.ingram at cariss.co.uk> wrote:
> >
> >> On 18/10/2013 11:52, Sharon Kimble wrote:
> >>> 'mysqladmin -u root -p ******** drop
> >>> Enter password:
> >>> mysqladmin: connect to server at 'localhost' failed
> >>> error: 'Access denied for user 'root'@'localhost' (using password:
> >>> YES)'
> >
> Safer I reckon to drop things with mysql client directly.. this is a
> default mysql database set, don't drop any of these except test,
> mysql needs them to store information about users, database objects
> and permissions.
> 
> ak at x:~$ mysql -u root -p
> Enter password:
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | mysql              |
> | performance_schema |
> | test               |
> +--------------------+
> 4 rows in set (0.01 sec)
> 
> mysql> drop database test;
> Query OK, 0 rows affected (0.00 sec)
> 
> I just walked through this howto and it works fine.
> 
> https://www.digitalocean.com/community/articles/how-to-install-linux-apache-mysql-php-lamp-stack-on-debian
> 
> 
Thanks Alan for this, I've been following it and here’s my output -
 apt-get install mysql-server
[sudo] password for boudiccas: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libhtml-template-perl mysql-server-5.5
Suggested packages:
  libipc-sharedcache-perl tinyca
The following NEW packages will be installed:
  libhtml-template-perl mysql-server mysql-server-5.5
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/2,183 kB of archives.
After this operation, 31.9 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 313674 files and directories currently installed.)
Unpacking mysql-server-5.5
(from .../mysql-server-5.5_5.5.31+dfsg-0+wheezy1_i386.deb) ...
Selecting previously unselected package libhtml-template-perl.
Unpacking libhtml-template-perl
(from .../libhtml-template-perl_2.91-1_all.deb) ... Selecting
previously unselected package mysql-server. Unpacking mysql-server
(from .../mysql-server_5.5.31+dfsg-0+wheezy1_all.deb) ... Processing
triggers for man-db ... Setting up mysql-server-5.5
(5.5.31+dfsg-0+wheezy1) ... [ ok ] Stopping MySQL database server:
mysqld. 131018 13:44:18 [Note] Plugin 'FEDERATED' is disabled. 131018
13:44:18 InnoDB: The InnoDB memory heap is disabled 131018 13:44:18
InnoDB: Mutexes and rw_locks use GCC atomic builtins 131018 13:44:18
InnoDB: Compressed tables use zlib 1.2.7 131018 13:44:18 InnoDB: Using
Linux native AIO 131018 13:44:18 InnoDB: Initializing buffer pool, size
= 128.0M 131018 13:44:18 InnoDB: Completed initialization of buffer pool
131018 13:44:18 InnoDB: highest supported file format is Barracuda.
131018 13:44:18  InnoDB: Waiting for the background threads to start
131018 13:44:19 InnoDB: 5.5.31 started; log sequence number 1595685
131018 13:44:19  InnoDB: Starting shutdown...
131018 13:44:20  InnoDB: Shutdown completed; log sequence number 1595685
[ ok ] Starting MySQL database server: mysqld ..
[info] Checking for tables which need an upgrade, are corrupt or were 
not closed cleanly..
Setting up libhtml-template-perl (2.91-1) ...
Setting up mysql-server (5.5.31+dfsg-0+wheezy1) ...
[boudiccas:Fri Oct 18 13:44:32 @~]$ [2738]>;  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: 
ERROR 1142 (42000) at line 1: UPDATE command denied to user
'root'@'localhost' for table 'user' Password update failed!
Cleaning up...
[boudiccas:Fri Oct 18 13:45:08 @~]$ [2738]>;  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): 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES) Enter current password for root (enter for none): 
Aborting!

Cleaning up...
[boudiccas:Fri Oct 18 13:45:56 @~]$ [2738]>; 

How do I force the database to completely drop/wipe the old, unknown,
root password? I've tried several without success. Or, alternatively,
how do I wipe the old database so I start completely afresh please?

Sharon.
-- 
A taste of linux = http://www.sharons.org.uk
efever = http://www.efever.blogspot.com/
efever = http://sharon04.livejournal.com/
my git repo = https://github.com/boudiccas/dots
Debian 7.2, Fluxbox 1.3.5, LibreOffice 4.1.0.4
Registered Linux user 561944
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: not available
URL: <http://mailman.lug.org.uk/pipermail/kent/attachments/20131018/688f86d2/attachment.pgp>