Category Archives: MySQL


mysql table does not exist

mysql table does not exist Mysql table does not exist, but it is there. I can see it when I run show databases. Did you manually move your database instead of export and import? Chances are your are using InnoDB Read more…


A short example on how to use the .net MySql connector with Mono Develop.First you need to make it available to your project.Go to Project -> Edit ReferencesSelect the .Net Assembly tab. Then Navigate to your folder containing Mysql.Data.dll and Read more…


Here is how to install a .net MySql connector for Mono Develop for Linux (Tested for Debian Variants). First we is going to download the connector, and you will find it here: http://dev.mysql.com/downloads/connector/net/ Just remember to download the right version Read more…


Haven’t needed to reset my MySQL root passwords yet, but I suspect someday…. On a Debian based system this is easy and also demonstrate the importance of restricting physical access to your server. First run (sudo or root): dpkg-reconfigure mysql-server-5.5 Read more…


Handy to know when installing WordPress, phpBB or any other fancy web applications requiring a database. First log on to your MySQL server (assuming root user is being used) mysql -u root -p When logged on, create the database (called Read more…


Setup a basic LAMP, enables you to host cool web applications. LAMP is Linux, Apache, MySQL & PHP (guess Perl or Python should qualify as well). I assume you have done at least a minimal Debian installation here.   Update Read more…


A few simple steps to install MySQL with remote root access on a Debian system.  Out of the box, as default, the root user can only log in from localhost. It’s easier to work from your laptop or workstation when Read more…