1

Using watch in !#

view story
linux-howto

http://crunchbang.org – Hello,Quick admin question. On machines in the past (CentOS) I would watch mysql queries being processed (usually but not always through cron) using this:watch -n 1 mysqadmin -u [user] -p processlistBut when I do that, it asks for a password, I enter it, can't see it of course, hit enter and nothing... The Enter Password prompt is still there.  I remembered that I can also dowatch -n 1 mysqladmin --user=[user] --password=[password] processlistAnd that works, but it leaves the mysql password in the auth.log so that's not a very good practice I'd imagine.  Am I using the (HowTos)

robot1's picture
Submitted by robot1 on 01/04/2013

Stories similar to Using watch in !#

I am use CentOS 5.5, mysql 5.1, php 5.3, phpmyadmin 3.4.5, I have set my mysql password with

>mysql update mysql.user Password="mypassword" where User="root"

And in phpmyadmin/libraries/config.default.php

Do:

$cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'mypassword';

Note: the 2 password are same.

Hello, I am attempting to connect my new Brother HL-2230 printer over CUPS. However, when I try to log in to http://localhost:631/admin it asks me for authentication. When I enter the user name for my administrator account (limao) and password, it reprompts me for my username and password again. using

Code: # lppasswd -a limao Enter password: Enter password again: was no help at all.

MySQL remote connect failing 2 years 19 weeks ago

Setup a new database on a machine I didn't setup. I can from the local machine issue a;

mysql -u root -p <enter>, submit the password and I'm in.

I read through http://dev.mysql.com/doc/refman/5.1/...ss-denied.html

and not sure on the issue.

mysql to mariadb upgrade 6 weeks 1 day ago

I wouldn't set a password for mysql that wasn't my root or main user password, but I still get this no matter what I try# mysql_upgrade -p Enter password: Phase 1/3: Fixing table and database names mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect FATAL ERROR: Upgrade failedI tried resetting the passwo

I just installed MySQL 5.5 and right after install I was asked to set root password by executing those two commands:

/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h linux-opxd password 'new-password'

or

/usr/bin/mysql_secure_installation

I executed first command -- OK.

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

When I start up Ubuntu 12.10 I see the login screen. I have my account and a guest account as the choices. When I choose my account by clicking on it, I automatically get logged in with out being required to enter my password.

I want to password protect my account so when someone clicks my account, they have to enter the proper password to get in.

If I run the script containing su -m user service userservice start under root user, I do not need to enter the password. But when I run it under user user, it asks passwords all the time. That really bugs me. Is it supposed to ask passwords for security reasons? Is there any way I could avoid asking password if su -m user command is run under user?

mysql 2 years 31 weeks ago

Unless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it.

Well I am not familiar with it, so I wam wondering how to do it.