When in a situation where the internet hosting site will only permit the use of one MySQL database and it is serving one WordPress installation, and you would like to serve more than one WordPress installation, then combine the multiple installations of WordPress into the same MySQL database. This can be accomplished using phpMyAdmin to select the default WordPress database…
Read More »LAMP, an open source web development platform based on Linux, is an acronym for Linux, Apache, MySQL, and PHP (Perl or Python). Using terminal, enter the following line to install the LAMP stack. sudo apt-get install apache2 mysql-server libapache2-mod-auth-mysql php5-mysql php5
Read More »On a test box running an older version of WAMP, I wanted to correct an installation oversight, the user root with no password. After installing several databases, I decided to change the user root password from no password to some password. After doing so, I immediately encountered the following error: #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)…
Read More »
While attempting to access a remote MySQL database, you may be presented with a permissions error. There are several ways to resolve this via command line or via MySQL Administrator a GUI. MySQL Administrator is a program for performing administrative operations, such as configuring, monitoring and starting and stopping a MySQL server, managing users and connections, performing backups, and a…
Read More »