I installed phpmyadmin in my Ubuntu 12 server, during the installation process with dbconfig-common I left the phpmyadmin password blank. The system said a random password will be generated. That's fantastic but.. where the hell do I find this password???  I searched the web high and low it seems I am the only one with this problem.
121236
I recently installed LAMP on Ubuntu 13.04(32-bit) but forgot my phpMyAdmin password. How can I reset its password without re-installing it?
38883
I was following this tutorial:    So far, I installed mysql-server mysql-client libmysqlclient-dev, and I was suppose to tell MySQL to create its database directory structure where it will store its information using sudo mysql_install_db.  $ sudo mysql_install_db  [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize [ERROR]   The data directory needs to be specified.   I thought running mysqld --initialize would solve the issue:  $ mysqld --initialize   mysqld: Can't create directory '/var/lib/mysql/' (Errcode: 17 - File exists) [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). [ERROR] Aborting   How do I tell MySQL to create its database directory structure where it will store its information?
105605
I frequently need to do the following things in MySQL:   Create a non-root user Set that user's password Grant that user all privileges Make a database with the same name as the new user Allow usage only for users from the localhost.   Previously I did this using PHPmyadmin, but I would prefer doing it directly from BASH. Is there a CLI way to execute these steps?
64915
I'm trying to install phpMyAdmin using sudo apt-get install phpmyadmin but encountering this error  Err http://gb.archive.ubuntu.com/ubuntu/ precise-updates/main mysql-common all 5.5.34-0ubuntu0.12.04.1   404  Not Found [IP: 194.169.254.10 80] Err http://security.ubuntu.com/ubuntu/ precise-security/main mysql-common all 5.5.34-0ubuntu0.12.04.1   404  Not Found [IP: 91.189.91.15 80] Err http://security.ubuntu.com/ubuntu/ precise-security/main libmysqlclient18 i386 5.5.34-0ubuntu0.12.04.1   404  Not Found [IP: 91.189.91.15 80] Err http://security.ubuntu.com/ubuntu/ precise-security/main mysql-client-core-5.5 i386 5.5.34-0ubuntu0.12.04.1   404  Not Found [IP: 91.189.91.15 80] Err http://security.ubuntu.com/ubuntu/ precise-security/main mysql-client-5.5 i386 5.5.34-0ubuntu0.12.04.1   404  Not Found [IP: 91.189.91.15 80] Err http://security.ubuntu.com/ubuntu/ precise-security/main mysql-client all 5.5.34-0ubuntu0.12.04.1   404  Not Found [IP: 91.189.91.15 80] Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.5/mysql-common_5.5.34-0ubuntu0.12.04.1_all.deb  404  Not Found [IP: 91.189.91.15 80] Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.5/libmysqlclient18_5.5.34-0ubuntu0.12.04.1_i386.deb  404  Not Found [IP: 91.189.91.15 80] Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.5/mysql-client-core-5.5_5.5.34-0ubuntu0.12.04.1_i386.deb  404  Not Found [IP: 91.189.91.15 80] Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.5/mysql-client-5.5_5.5.34-0ubuntu0.12.04.1_i386.deb  404  Not Found [IP: 91.189.91.15 80] Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.5/mysql-client_5.5.34-0ubuntu0.12.04.1_all.deb  404  Not Found [IP: 91.189.91.15 80] E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?   What could be the issue here? How do I solve it?
31817
I have installed mysql 5.7 on a Red Hat Enterprise Linux 5.5 server and when I tried to run following command after installation it is asking for a password for root@localhost.  /usr/bin/mysql_secure_installation   I have never set a root password and I'm logged in to Linux as root user.  Then I have found following documentation for resetting root password and followed that one too.    But even after starting the server with following command it is asking for a password  /etc/init.d/mysqld start --skip-grant-tables &amp;   I have tried starting the server with init-file option, but no success.  Does anyone know how to reset the password correctly or default MySQL password?
7114
I regularly set up Virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed:  1)VB guest additions no longer allow me to copy and paste (I'll worry about that later)  2)More importantly phpmyadmin no longer works as installed - Initially going to localhost/phpmyadmin gave a message that the page could not be found. So I have followed some instructions which told me to do the following in var/www:  sudo ln -s /usr/share/phpmyadmin phpmyadmin   which has created a phpmyadmin directory in /var/www but now I get an error saying:      the mysqli extension is missing.   If I run phpinfo mysql and mysqli are listed.  All I have done so far is   sudo apt-get update   sudo apt-get install apache2 sudo apt-get install php5 sudo apt-get install mysql-server   and   sudo apt-get install phpmyadmin    I found a post of a similar question which suggested I should do   sudo apt-get install php5-mysql   (I've done this) and edit php.ini and uncomment the line:  extension=mysqli.so   This is not there, so I tried adding it but no joy. I have restarted apache and still no phpmyadmin.  I'm running a windows 7 machine and the guest os is ubuntu 12.04
363
I forgot my root password...actually I think I know what it is because it is the same password I have for pretty much everything but in the Terminal in tell me "Sorry, try again." Is there a way to reset the password? If so how?
88130
I install mysql and phpmyadmin and in installation phpmyadmin i add config password is root but in connection with user is root and password is root i have this error
83828
It's got to be somewhere in the phpinfo() dump, but I just don't know where.  Is it supposed to be under the "Additional Modules" section?  Somewhere else?  I'm trying to figure out why some extensions don't appear to be loaded, but I don't even know where I should be looking.
120115
My site is on localhost and I have access to database too. This is the structure of "users" table:    The password field is of type "varchar(32)" having collection "utf8_general_ci". I tried to decrypt the password online but it displays that password can't decrypted.  I manually updated the table and changed the password using md5 but whenever I try to login to the site as admin, it displays "Access Denied".  How to change the password for site?
5495
I am not a administrator and I would like to find the administrator password. I would not like to reset it however. Is there anyway to find and not reset the administrator password?
56751
I'm using Ubuntu desktop 16.04 (upgraded from 15.10).  I had installed phpmyadmin from by apt-get install phpmyadmin. It works if I go to localhost/phpmyadmin but I cannot log into it as root.  I have searched a lot for it. I have found many sources in which they suggest to alter /etc/phpmyadmin/config.inc.php and replace the user and password with 'root' and '' (empty for password). But my config.inc.php is different from theirs. For example in my file, there is no line for user and password and it seems it gets it automatically from another file which is /etc/phpmyadmin/config-db.php. Despite this, I have changed the user and password in that file, but now I get this error:  #1698 - Access denied for user 'root'@'localhost'   What I should do?    Phpmyadmin Version: 4.5.4.1deb2ubuntu1 mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using  EditLine wrapper
106111
I have already uploaded some files in the free web host I chose and created a database there using phpMyAdmin v2.11.4  Also, I have Googled first this question before posting this here but I don't understand some rules and I need a clarification.  The exact error I get from viewing my uploaded file(index.php) is this:  Warning: mysqli_connect() [function.mysqli-connect]: (HY000/1130): Host '31.170.160.98' is not allowed to connect to this MySQL server in /home/a6400350/public_html/subdomains/index.php on line 7   Domain name of free web host I'm using is   And my php code for connecting to host is:  &lt;?php  $host = "sql10.000webhost.com"; //or "31.170.160.98" $username = "a6400350xxxxxx"; $password = "••••••••";  $con = mysqli_connect($host, $username, $password);  ?&gt;    I also check if the server is down  or it's just me There was also no previlege section in phpMyAdmin page as other suggest   Don't I have any permission to connect programmatically to this host as I am just a free user?  Edit     I'm also thinking of uploading the whole XAMPP in the server so I   could do the things I'm imagining.   Edit 2     Also one more thing, I imported the database by means of .sql file   locally through that server, maybe this has something to do about it?
96010
I need to reset the root password of my local mysql installation but it woudln't let me. I've tried this:  $ sudo /etc/init.d/mysql stop  * Stopping MySQL database server mysqld                                                                                                              [ OK ]  [1]-  Exit 1                  sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking [2]+  Exit 1                  sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking reg@regDesktopHome:~$ sudo mysqld --skip-grant-tables &amp; [1] 13651 reg@regDesktopHome:~$ 140627 19:02:02 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.  reg@regDesktopHome:~$ mysql -u root mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) reg@regDesktopHome:~$ sudo mysql -u root mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [1]+  Exit 1                  sudo mysqld --skip-grant-tables   How can I get the password reset? edit 1 I got this:  $ ps ax| grep mysql 16515 ?        Ssl    0:00 /usr/sbin/mysqld 16551 pts/23   S+     0:00 grep --color=auto mysql reg@regDesktopHome:~/semios/v3upgrade$ sudo kill -9 16515 reg@regDesktopHome:~/semios/v3upgrade$ ps ax| grep mysql 16678 ?        Ssl    0:00 /usr/sbin/mysqld 16715 pts/23   S+     0:00 grep --color=auto mysql reg@regDesktopHome:~/semios/v3upgrade$ mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)   looks like a process is automatically restarting mysql as soon as I kill it...
38456
I created a block and put in some invalid PHP code resulted in entire site not accessible at all.   I'm fairly new to Drupal and I'm not a back-end programmer either. Much appreciated if you can provide a clear step-by-step guide on how to delete that particular block directly from the Database (PhpMyAdmin).
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?
95688
How can I change my password?  I have looked around  but haven't found anything promising. A few answers got me close, but the advice always came from a more advanced user. I am new to the world of Linux however I feel I'm following the directions 100%.   I love Ubuntu &amp; I'm learning a lot of good information but I have been spending far to much energy &amp; time on what should be easy.