How to reset or delete or enter new password or see the password. If still unable to resolve, how to delete all MySQL dependency and reinstall fresh. I am new to Linux and this is my personal computer (laptop). Please see the output of my terminal.  pra@pra-K55N:~$ sudo mysql [sudo] password for pra:  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) pra@pra-K55N:~$ sudo mysql_secure_installation  Securing the MySQL server deployment.  Enter password for user root:  Error: Access denied for user 'root'@'localhost' (using password: YES) pra@pra-K55N:~$ sudo service mysql stop pra@pra-K55N:~$ sudo mysqld_safe --skip-grant-tables &amp; [1] 2466 pra@pra-K55N:~$ 2019-11-15T14:56:08.897357Z mysqld_safe Logging to syslog. 2019-11-15T14:56:08.907624Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2019-11-15T14:56:08.915473Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.  [1]+  Exit 1                  sudo mysqld_safe --skip-grant-tables pra@pra-K55N:~$ sudo mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) pra@pra-K55N:~$ sudo service mysql start pra@pra-K55N:~$ sudo mysql -u root -p Enter password:  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) pra@pra-K55N:~$    please see mysql.cnf  !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/
5583
In my server, everytime I try to access MySQL I get the error:        Access denied for user 'root'@'localhost' (using password: NO)   when I try mysqladmin -u root -p password I get        Access denied for user 'root'@'localhost' (using password: YES)   How can I access MySQL in my Ubuntu server 12.04?
38067
Whenever I try to do anything at all that requires my password it returns this:  u7ur7l3@ubuntu:~$ sudo sudo: /usr/lib/sudo/sudoers.so must be owned by uid 0 sudo: fatal error, unable to load plugins u7ur7l3@ubuntu:~$   So I can't install anything from the Software Center / package manager or run any commands in terminal that require my password. I can log in, but that's pretty much it.  I accidentally changed the permissions of some files, then changed some more trying to fix it :/. Now I'm completely lost as to what to do.  This is what happened when I tried to get sudo working again using pkexec:  u7ur7l3@ubuntu:~$ pkexec chown root /usr/lib/sudo/sudoers.so Error getting authority: Error initializing authority: Error calling StartServiceByName for org.freedesktop.PolicyKit1: GDBus.Error:org.freedesktop.DBus.Error.Spawn.ExecFailed: Failed to execute program /usr/lib/dbus-1.0/dbus-daemon-launch-helper: Success   u7ur7l3@ubuntu:~$ sudo ls sudo: /usr/lib/sudo/sudoers.so must be owned by uid 0 sudo: fatal error, unable to load plugins   And to change permissions I was using Root Actions as a dolphin service/ plugin thing, so history doesn't show me the permission changes.  I just realized that sounds don't work at all anymore. When I go into Phonon my default settings and playback devices aren't even there. Also I don't have the option to shutdown, I can only log out or leave.
49599
When I set the password to blank, it didn't give any warnings. Now when I try to log in with a blank password, it gives me an error "fe_sendauth: no password supplied". So now I can't log in - any ideas how I can get access to the db again?
115301
I'm trying to force a newly created user to change a password at the first time login using ssh. For security reasons I want to give him a secure password until he logs in for the first time. I did the following so far:  useradd -s /bin/bash -m -d /home/foo foo passwd foo   Doing chage -d 0 foo only gives me the the error Your account has expired; please contact your system administrator on ssh login.
108383
using this command I changed root password   mysqladmin -u root password fg$pkh@567fghu   And now I cant access mysql. Is this because mysql parse the chars other than what I expect?  Also I completely removed and installed mysql and Problem is extant. How do I remove mysql so that I get rid of password?
120831
I would like to restart mysql gracefully just like httpd where threads are served before restart. I would dislike queries breaking.
72208
I am pretty new to linux and LAMP setup. I want to setup a LAMP environment with AP on one linux server and M on a different linux server. I have a hard time finding a relevant document with such a configuration.  I have done the following steps so far:  server1:  yum install -y httpd /sbin/service httpd restart yum install -y php php-mysql sed -i "s/Listen 80/#Listen 80/g" /etc/httpd/conf/httpd.conf yum install -y mod_ssl openssl /sbin/service httpd restart service iptables stop   I changed the ServerName in /etc/httpd/conf/httpd.conf from  #ServerName www.example.com:80   to  ServerName 172.32.35.14 (ip address of server1) /sbin/service httpd restart   server2:  yum install -y mysql-libs yum install -y mysql yum install -y perl-DBI yum install -y perl-DBD-MySQL yum install -y mysql-server /sbin/chkconfig mysqld on /sbin/service mysqld start mysql -u root  -e "CREATE USER 'mysqluser' IDENTIFIED by 'password'"  mysql -u root  -e "CREATE USER 'mysqluser'@'localhost' IDENTIFIED by 'password'" mysql -u root  -e "GRANT ALL PRIVILEGES ON *.* TO 'mysqluser'@'localhost' WITH GRANT OPTION" mysql -u root  -e "GRANT ALL PRIVILEGES ON *.* TO 'mysqluser'@'%' WITH GRANT OPTION" mysql -u mysqluser -p password -e "CREATE DATABASE mysqldb"  mysql -u mysqluser -p password mysqldb &lt; /tmp/mysqlinstaller/world.sql service iptables stop   Then I had these post configuration steps:  On server 2, where my mysql is installed, I did the following:  bind-address = 172.32.35.14 (ip of server 1 where apache/php are installed) service mysql restart   But I am not able to establish a connection. Can you point out what I am missing and guide me please.
55502
I have a mysql installed inside a windows virtual machine. The hard drive was crashed and the system is not able to restore all again. But I can have access to entire c: ROOT. So I went to  c:/ProgramData/Mysql/Mysql Server 5.5/data/myDatabaseName    There I can see different files like: .frm, .opt, .trg and .trn. In a regular way, I could run a mysqldump to backup and restore all database from command line, but the system is not able to be restored. So I had to copy all these files and past inside inside the same  directory inside same database in another physical instance.   The issue is some tables are not been recognized by this new instance. So I think copy and past is not enough to restore the database.   What am I missing?    Note: Database has innoDb and Myisam tables.
6147
I want sudo to behave like this, for all users:   If the user currently has a non-empty password, prompt for the password. If the user currently has an empty password, either prompt for the password and accept the empty string, or don't prompt at all and permit.   Is this possible? Right now, I have (1) but this is what happens for a user with an empty password:  $ sudo echo Sorry, try again. Sorry, try again. Sorry, try again. sudo: 3 incorrect password attempts   Alternatively, I can switch off password checking per-user, but that's not what I want, because the user might set a password later, and then sudo should prompt for it.
7702
The /etc/passwd is supposed to have a line for every user on the system. Amongst the common username and root there is a bunch of other users. Some examples:  timidity:x:114:127:TiMidity++ MIDI sequencer service:/etc/timidity:/bin/false liquidsoap:x:115:128::/usr/share/liquidsoap:/bin/false statd:x:116:65534::/var/lib/nfs:/bin/false gdm:x:117:131:Gnome Display Manager:/var/lib/gdm:/bin/false mysql:x:118:133:MySQL Server,,,:/nonexistent:/bin/false    What's the purpose with all these users? How can I login as mysql or gdm? What will the password be?
24235
When I attempt to login to my admin account, I'm getting a 'Sorry, unrecognized username or password.' message. The weird thing is that the password and username are correct. I've looked them up in the SQL database. I've even tried changing the password in the database, but have had no luck getting it to work. After every 5 attempts, I've had to use the DELETE FROM 'flood'; sql command in order to reset the attempts.  In my local environment, I'm having no trouble logging in. This is also the first time I've attempted to login to the production website.   Is there anything I can try to fix this?
1117
Can I configure Fedora 22 so anything needing root privileges asks for a password, rather than giving an error, and needing me to re-run with sudo?  I wouldn't even mind having to type my password every time, without the few minute (or whatever it is) timer that it remembers the password for.  i.e. Instead of:  $ dnf history You don't have access to the history DB.   It would:  $ dnf history [sudo] password for &lt;username&gt;:   I think some of the gui apps do that, like the gui yum frontend back when I had that installed.  I'm thinking not... That it would be up to each app to implement this.  But, I'm hoping it might instead be that apps say root privilege is needed, and there might be some way for the kernel (or wherever else) to remain in a blocking input stage (for the password) before returning whether the user has access.
26509
I have a service (kado-demo.service) that a normal user (kado) should be able to restart without entering any password.   I created /etc/sudoers.d/user_restart and added  kado ALL=NOPASSWD: /bin/systemctl restart kado-demo.service   Permissions:  -r--r-----   1 root root   585 Mar  5 10:47 user_restart   As user k, I now should be able to execute the given command, but this happens:  /bin/systemctl restart kado-demo.service  ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===  Authentication is required to restart 'kado-demo.service'.   Multiple identities can be used for authentication:   (...)   Which is the same result as before I added the file.   The /etc/sudoers contains  #includedir /etc/sudoers.d   And I even get the same result when I add content of the user_restart file directly to /etc/sudoers.  I'm running out of ideas...
116000
I wrote a simple shell script to dump a specific mysql database. problem is it is prompting me for a password even though I provide on. The mysql db is version 5.0.27 if that matters. Here is the specific line I am using.  $MYSQLDUMP -u backup -p$MyPass $DB &gt; $DEST/$FILE   I tried several variations, but to no avail.
96562
I tried restarting the Mysql server but its not working for me. I am sure the server is running and the permissions on the folder /var/lib/mysql/ are correct (777).  When i tried to open the file mysql.sock, its giving me an error saying the file may be corrupt.  Please help me to log on to the mysql server.
117718
I'm working with a legacy application that is connected to a MySQL database (5.x). When I created two different users for the MySQL database with the same password, the hash of those passwords are the same.  Is there an option to enable salting of the passwords in mysql.user?
104197
When i create new User Account and login with that credentials, it gives me this problem if admin doesnt have set thier values yet !!!**  AllotmentList = [select id, Days_Remaining__c from PTO_Allotment__c where Year__c =:year and Employee__c=:EmployeeList[0].id LIMIT 100]; //access only Current user Allotment details                 //to handle Listoutof Bound Exception wrote if-else          if(AllotmentList.size()&gt;0)         {         requests.PTO_Allotment__c=AllotmentList[0].id;         requests.Days_Remaining__c=AllotmentList[0].Days_Remaining__c;         }         else         {             //write a code when AllotmentList is empty ....         }