[Klug-general] [SUCCESS] Re: Round and round, like a windmill in the sky!
Sharon Kimble
boudiccas at talktalk.net
Fri Oct 18 13:32:24 UTC 2013
On Fri, 18 Oct 2013 13:52:10 +0100
Sharon Kimble <boudiccas at talktalk.net> wrote:
> 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?
>
Right, I'm in. I removed mysql-server, renamed all folders for mysql,
and moved loose files into a 'cruft' folder. re-installed and followed
the page above. I used a blank password when it first asked me for one
and then set it and just followed through. And now i'm in.
Thanks folks, it is appreciated! :)
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/ee7ebb5e/attachment.pgp>
More information about the Kent
mailing list