Yesterday, I showed you how you can keep local installation of phpmyadmin from logging you out every few minutes. I took one more step and edited configuration to not ask me username, password at all. Now phpmyadmin never asks me for mysql username and password. Keep in mind if you follow this tutorial anyone would be able… Continue reading [HowTo] Stop phpmyadmin from asking username, password in localhost
Category: mysql
[HowTo] Extend phpmyadmin session expiration time
Recently, I got frustrated being logged out every few minutes (24 minutes, to be precise) from phpmyadmin on my localhost. I make some db changes, write some code and when I get back to phpmyadmin, I would see my session had expired. To fix this, I changed the configuration so that my session would expire… Continue reading [HowTo] Extend phpmyadmin session expiration time
[HOWTO] Reset MySQL root password on Ubuntu when you’ve forgotten it
To err is human. Humans forget things, MySQL root password is one of those things. However, its not very difficult to reset the root password if you have root access to the machine. The tutorial does seem a bit long because of all the alternate ways to kill and start the mysqld, but trust me… Continue reading [HOWTO] Reset MySQL root password on Ubuntu when you’ve forgotten it
[HOWTO] Use local phpmyadmin with remote MySQL
My host recently started allowing remote connections to its mysql database. It was a really useful feature – I could not change database settings from my own computer. Since it started allowing remote connections from my IP, I could use any mysql client to connect to it. I fired up terminal and tried to connect… Continue reading [HOWTO] Use local phpmyadmin with remote MySQL