A running easyapache process was detected. Please wait for easyapache to finish before attempting to upgrade MySQL

I am just setting a new server up, and i upgraded apache first. Now i went to upgrade MySQL to 5.5, but when i am going in the interface, it says:

WARNING: A running easyapache process was detected. Please wait for easyapache to finish before attempting to upgrade MySQL.

If you are certain that the easyapache is no longer running, you may restart the MySQL upgrade by clicking the following button.
The “Ignore current upgrade button” is not working. What do we do?

 

What you can do, is to run:

ps aux | grep easyapache

If it doesn’t return any process running, then go delete the following file:
/usr/local/apache/AN_EASYAPACHE_BUILD_IS_CURRENTLY_RUNNING

Enjoy!

Find all MySQL databases sizes

Okay, i just came onto this today, and i find it highly useful to get an sql database usage at a glance:

SELECT table_schema “Data Base Name”, SUM( data_length + index_length) / 1024 / 1024
“Data Base Size in MB” FROM information_schema.TABLES GROUP BY table_schema ;

LE: If you want to see the size of the tables in a certain db:

SELECT table_name AS “Tables”,  round(((data_length + index_length) / 1024 / 1024), 2) “Size in MB”  FROM information_schema.TABLES  WHERE table_schema = “your_database_name”;

MySQL – create user / add user to database

MySQL Add User FAQ: How do I add a user to MySQL (i.e., how do I create a MySQL user account)?

MySQL add user – solution

Solution: Here’s an example of what I did recently to (a) create a new MySQL database and then (b) add a new MySQL user account to work with that database. As usual, the database name, username, and password have been changed.

First, from my Unix prompt, I log into my MySQL database with the mysql command line client:

unix> mysql -u root -p
(here I enter ‘my_root_password’ to get through the mysql prompt)
Next, I create my new MySQL database with the “create database” command:

mysql> create database my_database;
And now I create a MySQL user account, giving the user account all the priviliges it needs to “own” this database, with the MySQL grant command. Note that I assign both the username and password when I add this MySQL user:

mysql> GRANT ALL PRIVILEGES
ON my_database.*
TO ‘my_user’@’localhost’
IDENTIFIED BY ‘my_password’
WITH GRANT OPTION;

php sql basics done

Am terminat cursul intr-un sfarsit. Clicky poza.

phpsql

Azi

Azi m-am trezit la 5, ca orice om normal care se trezeste la 5. Yea, real fun i know. Anyways, azi sper sa termin ultimele capitole de php/mysql de pe lynda.com, si trebuie sa completez aplicatia, asa ca va delectati doar cu 1 melodie si 1 trailer – chestii aleeeese pe spranceana. Voi distractie  – eu work, si  ne revedem un pic mai incolo, dupa ce o sa fiu mandru de mine.

Next project – bring Frankenstein back to life.