Re: Remove 'debian-sys-maint' Account?
Hi Carlos, The debian-sys-maint account is used for two things that I am aware of: 1) the /etc/init.d/mysql stop command uses it to perform a controlled shutdown of MySQL. 2) on execution of /etc/init.d/mysql start, it uses this account to run a CHECK TABLE on all of your tables The first function is quite handy, the second is downright annoying, especially if you have any large tables, as these will take a long time to check. There is a way of stopping it from performing the table check without disabling the maintenance account, but I can't remember it off-hand. Thanks On Tue, 2010-03-02 at 13:15 -0500, Carlos Williams wrote: I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 installed. It is a fresh install and I was checking all the system accounts and noticed that Debian has a 'debian-sys-maint' account on 'localhost'. Has anyone ever removed this account? Do I need it or can I safely remove this account? I don't understand why it's there. I don't want to break MySQL even though there is no data or databases on this machine but I would like to keep this as clean as possible. Thanks for any input. -Carlos -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Remove 'debian-sys-maint' Account?
Hi ALL, You will find all the details you need to set up debian-sys-maint account under /etc/mysql/debian.cnf GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'password' WITH GRANT OPTION Regards, Igor BTW, this is my First post. On Tue, Mar 2, 2010 at 6:15 PM, Carlos Williams carlosw...@gmail.comwrote: I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 installed. It is a fresh install and I was checking all the system accounts and noticed that Debian has a 'debian-sys-maint' account on 'localhost'. Has anyone ever removed this account? Do I need it or can I safely remove this account? I don't understand why it's there. I don't want to break MySQL even though there is no data or databases on this machine but I would like to keep this as clean as possible. Thanks for any input. -Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=nixofort...@googlemail.com
Re: Remove 'debian-sys-maint' Account?
On Tue, Mar 2, 2010 at 7:15 PM, Carlos Williams carlosw...@gmail.comwrote: I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 installed. It is a fresh install and I was checking all the system accounts and noticed that Debian has a 'debian-sys-maint' account on 'localhost'. Has anyone ever removed this account? Do I need it or can I safely remove this account? I don't understand why it's there. I don't want to break MySQL even though there is no data or databases on this machine but I would like to keep this as clean as possible. As Ian already indicated, this is an administrative account used by Debian for the system operations they do. It'll probably also be used when you upgrade packages and similar things. I would recommend that you keep it, as it's only there for localhost anyway, and the credentials are in /etc/mysql/debian.cnf with restricted readability. I also tend to use those credentials for any maintenance scripts I run myself, so in that way it actually prevents clutter for me :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Remove 'debian-sys-maint' Account?
I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 installed. It is a fresh install and I was checking all the system accounts and noticed that Debian has a 'debian-sys-maint' account on 'localhost'. Has anyone ever removed this account? Do I need it or can I safely remove this account? I don't understand why it's there. I don't want to break MySQL even though there is no data or databases on this machine but I would like to keep this as clean as possible. Thanks for any input. -Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Access denied for user 'debian-sys-maint'@'localhost'
Hi Jesse, If you're specifying the password in plain text, you shouldn't put the PASSWORD directive in there; you only use PASSWORD if you're using the hashed password that MySQL will actually store. GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'LongPasswordHere' WITH GRANT OPTION or GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'HexadecimalString' WITH GRANT OPTION Also, you will need to execute FLUSH PRIVILEGES once you're done, since MySQL normally only checks the privilege tables on start-up. On Mon, 2008-07-21 at 20:35 -0400, Jesse wrote: OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- Ian Simpson System Administrator MyJobGroup This email may contain confidential information and is intended for the recipient(s) only. If an addressing or transmission error has misdirected this email, please notify the author by replying to this email. If you are not the intended recipient(s) disclosure, distribution, copying or printing of this email is strictly prohibited and you should destroy this mail. Information or opinions in this message shall not be treated as neither given nor endorsed by the company. Neither the company nor the sender accepts any responsibility for viruses or other destructive elements and it is your responsibility to scan any attachments.
Re: Access denied for user 'debian-sys-maint'@'localhost'
That was it. Once I removed PASSWORD, it went through, and I'm able to restart MySQL now. Thanks for your help. Jesse - Original Message - From: Ian Simpson To: Jesse Cc: MySQL List Sent: Tuesday, July 22, 2008 4:48 AM Subject: Re: Access denied for user 'debian-sys-maint'@'localhost' Hi Jesse, If you're specifying the password in plain text, you shouldn't put the PASSWORD directive in there; you only use PASSWORD if you're using the hashed password that MySQL will actually store.
Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user 'debian-sys-maint'@'localhost'
Do you login via sock or network ? Didja change the passwd for localhost and % ? --Original Message-- From: Jesse To: MySQL List Sent: Jul 21, 2008 17:35 Subject: Access denied for user 'debian-sys-maint'@'localhost' OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Sent via BlackBerry from T-Mobile
Re: debian-sys-maint
The script mysql_install_db will initilize all the data in database mysql. So the user you created losted certaintly. On Jan 4, 2008 3:10 PM, Chris [EMAIL PROTECTED] wrote: Krishna Chandra Prajapati wrote: Hi all, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. Read the /etc/mysql/debian-start file to see everything that debian does when mysql starts up. It uses the debian-sys-maint user for all of those tasks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
debian-sys-maint
Hi all, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. After stopping mysql. If i delete all the things from mysql data directory. Executed mysql_install_db to create mysql directory with mysql data directory and start mysql server. It gives warning it don't found the debian-sys-maint user. I am trying to restart and stop mysql server, but it is not working. What can be the issue. Thanks, -- Krishna Chandra Prajapati
Re: debian-sys-maint
Hello, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. After stopping mysql. If i delete all the things from mysql data directory. Executed mysql_install_db to create mysql directory with mysql data directory and start mysql server. It gives warning it don't found the debian-sys-maint user. Corrupt Mysql-Debian installation? What kind of Debian version? Etch, Testing, Sid?? Try to purge and reinstall mysql-server. -- Best Regards Vlad Vorobiev http://www.mymir.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: debian-sys-maint
Hi , mysql server started with warning and working properly. But it is not stopping and not restarting. Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Krishna Chandra Prajapati On Jan 4, 2008 11:04 AM, Vladislav Vorobiev [EMAIL PROTECTED] wrote: Hello, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. After stopping mysql. If i delete all the things from mysql data directory. Executed mysql_install_db to create mysql directory with mysql data directory and start mysql server. It gives warning it don't found the debian-sys-maint user. Corrupt Mysql-Debian installation? What kind of Debian version? Etch, Testing, Sid?? Try to purge and reinstall mysql-server. -- Best Regards Vlad Vorobiev http://www.mymir.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: debian-sys-maint
mysql server started with warning and working properly. But it is not stopping and not restarting. Server version: 5.0.32-Debian_7etch1-log Debian etch distribution I have never had problems with mysql installation on Debian. I would try to reinstall mysql. Something like this: killall -9 mysql-server (make backup of your data) dpkg -r mysql* dpkg --purge mysql* apt-get install mysql-server -- Best Regards Vladislav Vorobiev http://www.mymir.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: debian-sys-maint
This is one of the few decisions the debian package maintainers made that I disagree with, but the idea is that when you install mysql, there is this user created with a random password. This gives the package maintainers a way to script updates in SQL if necessary to run on the database during an upgrade. The SysV startup script uses this account somehow (I forget now and I'm too lazy to open it up in a text editor) but that's what's generating the warning. Not MySQL. It's just a shell script warning. Edit the startup script and remove the user. It won't affect anything but you may get some errors during an upgrade at some point if they decide to use it. It's not a big security issue unless someone gets root access to the server, but if that's the case, I don't think mysql security will rank among the greatest of your worries. -Micah On 01/03/2008 09:23 PM, Krishna Chandra Prajapati wrote: Hi all, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. After stopping mysql. If i delete all the things from mysql data directory. Executed mysql_install_db to create mysql directory with mysql data directory and start mysql server. It gives warning it don't found the debian-sys-maint user. I am trying to restart and stop mysql server, but it is not working. What can be the issue. Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: debian-sys-maint
Krishna Chandra Prajapati wrote: Hi all, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. Read the /etc/mysql/debian-start file to see everything that debian does when mysql starts up. It uses the debian-sys-maint user for all of those tasks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]