Tag: MySQL

A MySql ibdata1 Optimization Technique

A MySql database needed to be removed and upon deletion of that single database, the extremely large three gigabite ibdata1 (data) file remained. Here are the steps I took to reduce or shrink the file once the database was removed. Since there was no other use for this MySql installation, there remained the MySql system databases. Show Databases At the…

Read More »

BigDump for large MySQL Databases

BigDump performs a staggered import of large and very large MySQL dumps similar to those of the phpMyAdmin 2.x dumps into a new or an existing MySQL database. Other reasons for using this script is if in the even access to the server shell is not possible or for what ever the reason the import fails using phpMyAdmin due to…

Read More »

Configure Sockso 1.1.1 Personal Media Server to use MySQL

Sockso is a free, open-source, personal music server. It’s designed to be as simple as possible so that anyone with a mouse and some mp3’s can get their friends listening to their music across the internet or intranet in seconds! Having tested the latest version 1.1.1, I have found that this application to be quite efficent and useful in it’s…

Read More »

Instantly populate a FileZilla fzdefaults.xml file and distribute

A group of users needed to change from one FTP client application to another. There was no conversion available for the original FTP application, only a spreadsheet that had been maintained. There was a need to bulk add a couple of hundred ftp accounts into a new FTP client. The selected FTP client is FileZilla. A little known tidbit about…

Read More »

WordPress – How to Move Blog to New Domain or Location

In most cases, the host of a WordPress installation is not the same as the test installation. In the case of testing plugins, themes, and WordPress versions, an exact installation of the original WordPress install would be the best scenario. In other cases, a WordPress installation hosted by an ISP may need to be copied to another ISP. A name…

Read More »

Combine multiple installations of WordPress into the same MySQL database.

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 »

How To: Install LAMP on Ubuntu Linux

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 two lines to install the LAMP stack. CODE sudo apt-get install apache2 mysql-server libapache2-mod-auth-mysql php5-mysql php5

Read More »

#1045 – Access denied for user ‘root’@’localhost’ (using password: NO) fix

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 immediatly encountered the following error: #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)…

Read More »

Cannot connect to remote MySQL database. Resolution.

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 »