MySQL

Apple MacBook Pro phpMyAdmin Apple MacBook Pro phpMyAdmin

Welcome to part 3 of the MAMP tutorial. In this post we will go over setting up phpMyAdmin on your Mac’s localhost. Part 2 walks you through installing mysql on your localhost read. Part 1 shows you how to setup up Apache on your Mac.

Read More How to setup phpMyAdmin on a Mac with OSX 10.8 + (MAMP Part 3)

I’ve been setting up a LEMP server, Nginx Mysql PHP, on Ubuntu and lost my root mysql password. Here’s what I did to reset the password in Terminal. After logging into my server via SSH on Terminal I ran the following lines in Terminal. # /etc/init.d/mysql stop # mysqld_safe –skip-grant-tables & $ mysql -u root…

Read More How to reset the root mysql password if you forget it

Recently our servers went down. The error we were getting was “Too many connections”. This meant that we needed to increase the limit on the number of available connections within our mysql config file. The setting is called max_connections Before you go upping the number of max user connections there are two things to consider.…

Read More What to do when you have the error “too many connections”