Tag Archives: mysql

Recover MySQL root password

Need to recover your MySQL database password from a Windows server? At the command prompt type – net stop mysql (your service name) Find your my.ini and edit the my.ini file. Add the following  under [mysqld] skip-grant-tables Save At the command prompt … Continue reading

Posted in Technology | Tagged , , , | Leave a comment

GUI Maintenance Program for MySQL / MSSQL and Windows

Want an excellent program to manage your MySQL server from Windows?  With MySQL, you can download MySQL Workbench.  MySQL Workbench offers great graphics on your MySQL incident and an interface that offers features such as queries and status of your … Continue reading

Posted in Technology | Tagged , , , , , , , , | Leave a comment

Increase performance on MySQL with a SSD and modifying your my.ini or my.cnf file

Always backup your data along with the my.ini or my.cnf file To add to the performance of a MySQL database, there are many tweaks for the my.ini or my.cnf file.  Two things that you can do is first add a … Continue reading

Posted in Technology | Tagged , , , , | Leave a comment

Learn SQL Databasing

A few links to SQL tutorials – http://www.w3schools.com/sql/ http://www.sqlcourse.com/ http://www.1keydata.com/sql/sql.html http://sqlzoo.net/wiki/Main_Page

Posted in Technology | Tagged , , , | Leave a comment

Learn SQL with these Online Emulators

SQLCourse has been around for sometime.   With Microsoft’s DreamSpark, students can download SQL Server to build databases and to learn how to retrieve data by performing queries  (basically asking the database for specific data).   SQLCourse gives you step by step … Continue reading

Posted in Technology | Tagged , , , , , | Leave a comment

MySQL Wworkbench – manage your MySQL installation

If you are a beginner or an expert, MySQL Workbench is a must have if you have installed MySQL.  The community edition allows you to Start/Stop your MySQL instance, write queries, monitor performance and has dozens of other features. With … Continue reading

Posted in Computers, Education, freeware, Industry, Information Technology, Software, Windows | Tagged , , , | Leave a comment

MySQL Upgrade in Windows

Dawn and I faced a MySQL Upgrade for our Moodle LMS site and delayed as long as we could.   Unlike traditional upgrades of Microsoft SQL, we couldn’t simply click a setup file and the upgrade would replace files and … Continue reading

Posted in Computers, Education, Industry, Information Technology, Manufacturing, network, Networking, Software, Technology, Windows | Tagged , , , , | 1 Comment

Optimizing MySQL on Server 2008 R2

Server 2008 R2 install Wincache by Microsoft Optimizing IIS (http://msdn.microsoft.com/en-us/library/ee377050(v=bts.10).aspx) Edit the my.ini file found in the MySQL installation http://dev.mysql.com/doc/refman/5.0/en/optimization.html Set the innodb_buffer_pool_size=1G   Resource Set the Max_Allowed_Packet = 100M Set Key_Buffer_Size=512M Set query_cache_size = 128MB query_cache_limit = 4MB table_cache=512 tmp_table_size = … Continue reading

Posted in Computer hardware, Computers, Education, freeware, Information Technology, Linux, network, Networking, Software, Technology, Windows | Tagged , , , , | Leave a comment

MySQL problem writing to database during cron backup

If you receive the error “!!!Error Writing To Database!!!” during a cron backup, this can be related to Find the my.ini file which is normally located in the MySql folder under program files (C:\Program Files\MySQL\MySQL Server 5.1).  Edit it by adding … Continue reading

Posted in Technology | Tagged , , , , , | Leave a comment

Expect A Surge In Breaches Following MySQL Vulnerability – Dark Reading

Vulnerability is so easily attacked and so prevalent that we’re bound for a bump in database exposures….Expect A Surge In Breaches Following MySQL Vulnerability – Dark Reading.

Posted in Computers | Tagged , , , , | Leave a comment

In Ironic Twist, MySQL’s Own Database Is Hacked Via SQL Injection – Darkreading

In Ironic Twist, MySQL’s Own Database Is Hacked Via SQL Injection – Darkreading. MySQL, which offers open-source database software and services for enterprises, is a leading provider of tools for small and midsize businesses. In an ironic twist, the attackers … Continue reading

Posted in Computers | Tagged , , , , | Leave a comment

Oracle and Sun end of VirtualBox, OpenOffice and MySQL?

There I was worried about IBM buying Sun and wham!  Oracle bought them at roughly $10 per share.   When several companies have bought out other companies, usually the first to go is the freebies (these cost money – programmers – … Continue reading

Posted in Technology | Tagged , , , , , , | 1 Comment