Difference Between Integer Types in MySQL and Their Max Values

In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned. The following table shows the values that different integer types (signed/unsigned) can hold: Integer Type Start Value End Value TINYINT -128 127 TINYINT (Unsigned) 0 256 SMALLINT -32,768 32,767 SMALLINT (Unsigned) 0 65,535 MEDIUMINT -8,388,608 8,388,607 MEDIUMINT (Unsigned) 0 16,777,215

Continue Reading

How To Install IonCube Loader On MAMP On Your Mac

MAMP (Mac, Apache, MySQL, PHP) is a package that allows you to run your own PHP-enabled web server with MySQL easily on your Mac. However, if you’re looking for additional libraries like the ionCube libraries, you’ll need to download and install them yourself. That’s not bad because it’s not hard at all. What you need is to go to http://www.ioncube.com/loaders.php, and download the ionCube loader file for your O/S version. For example, I’m running a Macbook Pro unibody, and so

Continue Reading

How To Reset The MySQL Root User Password and Privileges

Problem: I was developing using PHPMyAdmin when I added a new root user (with a host value of %), and removed the rights of the default root user. When you do that, you’ll get a gut-wrenching feel that you just made a huge boo-boo, find that suddenly everything will not work, and kick yourself in the ass. Fortunately, you have a fix. It’s in the mysqld –skip-grant-tables command, but you can’t just run it directly. First of all, fire up

Continue Reading

Site Footer

Sliding Sidebar

Disclaimer

The contents on this blog are not intended as professional advice. The author disclaims any liability, loss, or risk taken by individuals who directly or indirectly act on the information contained on this blog.