NEWS CATEGORIES:



NEWS ARCHIVE >>
SOFTPEDIA REVIEWS >>
MEET THE EDITORS >>
Home > News > Tags > MySQL

Stories about: MySQL


Amazon Launches Hosted Relational Database Service

Amazon may be known for its online retail business but it is also one of the biggest players in cloud computing. The company is offering a range of cloud services to cater to the needs of developers or companies that don't want the hassle of managing their own infrastructure. Up till now Amazon offered cloud sto...

27 October 2009
11:12 GMT

MySQL Creator Urges Oracle to Spin Off the Database

Oracle's Sun acquisition is raising even more concerns, this time about the future of MySQL, the open-source database system. As the EC investigation of the proposed acquisition lingers, MySQL is bleeding customers while its creator is asking Oracle to sell off the unit to a third party with no conflicting inter...

20 October 2009
09:13 GMT

Oracle-Sun Deal Approved by the DOJ

The Oracle-Sun deal made another big step toward being finalized after the US Department of Justice has announced it is approving the deal and that all of the anti-trust concerns have been settled. Oracle announced its intentions to buy Sun Microsystems several months ago for $7.4 billion. The deal has passed a few h...

21 August 2009
04:01 GMT

Oracle Increases Prices on Some Database Components

Everyone's feeling the economic downturn and, while some have fared better than others, even the big companies are turning to new ways of generating more revenue. Oracle, one of the leading database and enterprise software manufacturers in the world, has increased the price of some of its products by a full 40 p...

18 July 2009
07:22 GMT

Sun Shareholders Approve Oracle Merger

Almost three months since it was first announced, Sun Microsystems shareholders approved the deal with Oracle. In April Oracle announced it would acquire the tech company for about $7.4 billion, buying common stock at $9.50 per share, leading to much debate about the future of some of Sun's products and technolo...

17 July 2009
07:26 GMT

Human Resources Management on Autopilot with OrangeHRM

With over 129000 downloads since february 2006, OrangeHRM has proven that it could be a potential leader on the market of open source HRM (Human Resources Management) software. OrangeHRM is an HRIS (Human Resources Information System) that creates a logic bridge between HRM and information processing through web bas...

12 June 2008
12:02 GMT

Sun Microsystems Completes The Acquisition of MySQL

Sun Microsystems announced yesterday that it has completed the acquisition of MySQL AB, the developer of the most popular open source database, for approximately $1 billion. MySQL's complete portfolio of products and enterprise services were unveiled and are available for use.Sun provides a single and secure cho...

27 February 2008
10:29 GMT

Sun Microsystems Acquires MySQL

Sun Microsystems today announced that it will purchase MySQL AB, the developing company of the fastest growing open source database solution for approximately $1 billion.Thanks to the integration with Sun, the commercial appeal of MySQL's offerings will greatly increase. Through Sun's channels MySQL will ga...

16 January 2008
10:05 GMT

On Your Way Out, Sign the Guestbook, Please...

A Guestbook is a form that enables visitors to add comments on a web page. The best way to make users post their comments is to let them sign the guestbook without forcing them to create an account. And if the guestbook script is freeware, you must include a guestbook into your website.Jax Guestbook comes along with ...

10 October 2007
10:04 GMT

MySQL to Be Used by The Swedish Police

MySQL AB, the developer of the most famous open source database has announced today that the Swedish National Police is implementing an enterprise-wide project for building all its new IT systems on an open source software infrastructure that uses Linux, MySQL and JBoss. At this moment, some existing systems are bein...

3 October 2007
08:54 GMT

How to Repair Tables in MySQL

If you got an error from the table handler, the best way to see what it means is to run in command prompt the command perror nnn, where nnn is the number of the error.C:/xampp/mysql/bin>perror 145MySQL error code 145: Table was marked as crashed and should be repairedIf you want to repair a table from the command pro...

29 September 2007
06:55 GMT

How to Reset Root Password on MySQL

One of the most disturbing and embarrassing situations is when you forget a password. And if that password is from your MySQL server, you are in big trouble. But every time there is a solution for every problem. You can set-up a new password using the following method.In Windows environment, make sure you are logged ...

28 September 2007
11:07 GMT

How to Assign a Password to the Root Account on MySQL

In yesterday's article I told you how to secure the anonymous accounts on MySQL. If you want to setup a password for root account, you have three possibilities.The first method is identical with the one used to assign passwords for anonymous accounts. For that we will use the SET PASSWORD method. The steps are: ...

28 September 2007
10:11 GMT

How to Secure Accounts in MySQL

After you installed MySQL to your machine, the installation program will create superuser accounts (one in Windows environment and two in UNIX environment) and anonymous accounts (2 in Windows and 2 in UNIX). With the superuser account, named root, you can do anything. The bad news is that it is created without any p...

27 September 2007
11:07 GMT

How to Optimize Your MySQL Data Files

The first method to optimize your database is to make the tables for it as small as you possibly can. If you manage to do this, disk reads are faster, and smaller tables normally require less main memory while their contents are being actively processed during query execution. If the columns are also very small the i...

24 September 2007
10:59 GMT

How to Secure Your Password for MySQL

The first way to keep your password secure is to secure the user grant table and never give access to it to users that aren't in the administrative group. Another way to secure your password is to prevent running programs that connect to your SQL server and users can see the password through that program. To pre...

24 September 2007
10:11 GMT

Installation and Database Configuration of CakePHP

Now that you know what CakePHP is and what you can do with it, I will help you to install it so you may start building your first application. Before starting downloading the installation kit, verify if you comply with the requirements: a webserver (Apache, IIS, etc), PHP (4.3.2 or greater) and a database server (MyS...

13 September 2007
11:16 GMT

How to Check MySQL Tables for Upgrade

When you upgrade MySQL, you should check all tables from all databases for incompatibilities. To do this, you can use the mysql_upgrade program. You can use mysql_upgrade to upgrade the system tables so that you can take advantage of new privileges or capabilities that might have been added.When you run the utility, ...

7 September 2007
09:53 GMT

MySQL Migration Toolkit

One of the biggest problems of a database administrator is migrating from a proprietary database to MySQL. Using MySQL Migration Toolkit you can migrate from Microsoft SQL Server, Oracle, Microsoft Access, Sybase databases to MySQL database quickly and without problems.You can find Mysql Migration toolkit in MySQL G...

31 August 2007
10:45 GMT

MySQL Query Browser

To create queries for your database you can use the MySQL command line client, PHPMyAdmin (administers MySQL databases over the web using your browser), MySQL Query Browser (is included in MySQL GUI Tools) or another commercial product(Navicat). If you don`t like to work with queries in command line, you can try MySQ...

31 August 2007
09:57 GMT

Install Multiple MySQL Services

If you want to test the new version of MySQL without compromising your existing MySQL settings, you can run multiple instances of MySQL as services. You can install MySQL services using the --install or --install-manual option: - If you don't specify any service name, the server will use the default service name...

29 August 2007
09:53 GMT

How to Limit Account Resources in MySQL

If you use MySQL 5.1 you can limit the following server resources for individual accounts: the number of queries that an account can issue per hour, the number of updates that an account can issue per hour and the number of times an account can connect to the server per hour. You can also limit the number of simultan...

29 August 2007
09:00 GMT

How to Copy an MYSQL Database from One Computer to Another

If you want to transfer a database to another system with a different architecture, try mysqldump to create a file with all the statements from your database. To see what options are available, type mysqldump --help. In addition, you can use mysql --opt command if you move the database to a newer version of MySQL. Us...

28 August 2007
09:05 GMT

Install Rails on Windows Using Cygwin

Ruby on Rails is an open source Ruby framework for developing web-based, database-driven applications. Ruby on Rails divides itself into various packages, namely Active Record, Action Pack, Active Support, Action Mailer and Action Web Service. In addition, Developers can create plugins to extend existing packages.Rub...

22 August 2007
12:31 GMT

Create MySQL database backup

Like webservers, most MySql servers should remain online 24/7. That is why you should create periodical backups for your database. Because mysql datafiles are stored on the webserver, this makes the backup and restore process very easy to understand.In bin folder from your mysql install directory you can find mysqldu...

20 August 2007
10:50 GMT

Introductory Note on TYPO3

Typo3 is an open source content management system built with PHP and running on MySQL and Apache. Typo3 has 2 main parts: Core and Extensions. The Core is the foundation and Extensions adds specialized functions to the core. Typo3 is very modular, so, if you are a developer, you can quickly create your own extensions...

20 August 2007
10:35 GMT

Install and configure MySQL for Windows

MySQL Database is the most popular open source database because of its consistent fast performance, high reliability and ease of use. MySQL was released on March 23, 1995 and for Windows on January 8, 1998. MySQL works on many different platforms-including AIX, BSDi, Novell NetWare, FreeBSD, SunOS HP-UX, GNU/Linux, M...

18 August 2007
06:55 GMT

Google Releases Downloadable MySQL Patches

Although it might sound a little weird, Google is using MySQL for some of the applications that are not based on the search technologies. As you might know, MySQL is a database management system that was designed by the Swedish company MySQL AB. According to a blog post published today, the company's employees a...

25 April 2007
03:41 GMT


Windows tabGames tabDrivers tabMac tabLinux tabScripts tabMobile tabHandheld tabGadgets tabNews tab

SUBMIT PROGRAM   |   ADVERTISE   |   GET HELP   |   SEND US FEEDBACK   |   RSS FEEDS   |   ENTER NEWS SITE   |   ENGLISH BOARD   |   ROMANIAN FORUM