    % mysql --user=root mysql
    CREATE USER &#39;monty&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;some_pass&#39;;
    GRANT ALL PRIVILEGES ON *.* TO &#39;monty&#39;@&#39;localhost&#39; WITH GRANT OPTION;
    CREATE USER &#39;monty&#39;@&#39;%&#39; IDENTIFIED BY &#39;some_pass&#39;;
    GRANT ALL PRIVILEGES ON *.* TO &#39;monty&#39;@&#39;%&#39; WITH GRANT OPTION;
    CREATE USER &#39;admin&#39;@&#39;localhost&#39;;
    GRANT RELOAD,PROCESS ON *.* TO &#39;admin&#39;@&#39;localhost&#39;;
    CREATE USER &#39;dummy&#39;@&#39;localhost&#39;;
    FLUSH PRIVILEGES;

I&#39;ve had no problems installing Symfony 2.2.x using Composer, I&#39;ve always just copied the stable version at http://symfony.com/download.

    composer create-project symfony/framework-standard-edition myproject/ 2.2.1

*(I have Composer installed globally)*&lt;br/&gt;
Curious about 2.3.0-RC1 I figured this would go smoothly:

    composer create-project symfony/framework-standard-edition mynewerproject/ 2.3.0-RC1

But got shutdown by the following errors:

    Your requirements could not be resolved to an installable set of packages.
    
    Problem 1
        - symfony/icu v1.2.0-RC1 requires lib-icu &gt;=4.4 -&gt; the requested linked library icu has the wrong version installed or is missing from your system, make sure to have the extension providing it.
        - symfony/icu v1.1.0-RC1 requires lib-icu &gt;=3.8 -&gt; the requested linked library icu has the wrong version installed or is missing from your system, make sure to have the extension providing it.
        - symfony/symfony v2.3.0-RC1 requires symfony/icu &gt;=1.0,&lt;2.0 -&gt; satisfiable by symfony/icu[v1.1.0-RC1, v1.2.0-RC1].
        - Installation request for symfony/symfony 2.3.* -&gt; satisfiable by symfony/symfony[v2.3.0-RC1].

Do I need to tweak the composer.json file?

------
## Solution Update

### I was missing the [php intl extension][1] which provides *lib-icu*
So easy, install and configure the intl extension. As of PHP 5.3 the Intl extension is distributed by default, but some distributions, like MAMP, don&#39;t have Intl so you&#39;ll need to acquire it. I used **PEAR**:

**My steps:**

* Install the Intl extension (maintained by PECL): `$ pear install pecl/intl` — you may have to add the pecl channel to pear first.
* **If you use MAMP** and have never worked with pear/pecl check [lullabot&#39;s helpful blog post][2]; MAMP doesn&#39;t ship with the php source, so you have to [download the source for your php version][3] and move the source into `/Applications/MAMP/bin/php/php[version]/include/php` (as covered in the blog post)
* PEAR couldn&#39;t find my php.ini, so I had to manually add `extension=intl.so` to php.ini. In MAMP you can edit php.ini easily by going to File &gt; Edit Template &gt; php.[version].ini

**Command Line:**

* When using Composer or Symfony&#39;s Console CLI you&#39;ll also need Intl and since the `php` CLI usually uses a different `php.ini` you&#39;ll want to add the extension directive there too. To find your CLI&#39;s php.ini simply do `$ php -i |grep php\.ini` to discover the file path and add `extension=intl.so` to that php.ini as well.
* To check if Intl is installed you can do `$ php -m` to check available modules.

  [1]: http://www.php.net/manual/en/intl.installation.php
  [2]: http://www.lullabot.com/blog/articles/installing-php-pear-and-pecl-extensions-mamp-mac-os-x-107-lion
  [3]: http://php.net/releases/index.php

Problems with lib-icu dependency when installing Symfony 2.3.x via Composer

I wanted to debug the `Seed()` method in my Entity Framework database configuration class when I run `Update-Database` from the Package Manager Console but didn&#39;t know how to do it.  I wanted to share the solution with others in case they have the same issue.

Debugging Package Manager Console Update-Database Seed Method

How do I create a user with the same privileges as root in  MySQL/MariaDB?.


How do I create a user with the same privileges as root in MySQL/MariaDB?

<p>How do I create a user with the same privileges as root in  MySQL/MariaDB?.</p>


SQL How to replace values of select return?

I have added the following simple test event on my mysql database via phpmyadmin:

    CREATE DEFINER=`root`@`localhost` EVENT `my_event` 
    ON SCHEDULE EVERY 1 MINUTE STARTS &#39;2013-05-27 00:00:00&#39; 
    ON COMPLETION NOT PRESERVE ENABLE DO 
    BEGIN
        UPDATE `test` SET `name`=&quot;z&quot;;
    END

My environment is mac + MAMP Pro. I am expecting to change all rows on my &#39;test&#39; table with name &#39;z&#39; within a minute. But not happening so.

Do I have to something additional to get my events start working? 

Output of &quot;SHOW PROCESSLIST&quot;:
![enter image description here][1]

Thanks.


  [1]: http://i.stack.imgur.com/Xj2j9.png

Mysql Event Not Working

Assuming there is a remote server and I have phpMyAdmin client installed localy on my computer. How can I access this server and manage it via phpMyAdmin client? Is that possible? 

How to access remote server with local phpMyAdmin client?

I am a MSSQL user and now I am converting my database to MySQL. I am writing the following query in MySQL:

    SELECT * INTO new_tbl FROM tbl;

And I get the following error

    Error : Undeclared variable new_tbl

How such a query should be properly written in MySQL?

SELECT INTO in MySQL

How can I make this query in Laravel:

    SELECT 
    	`p`.`id`,
    	`p`.`name`, 
    	`p`.`img`, 
    	`p`.`safe_name`, 
    	`p`.`sku`, 
    	`p`.`productstatusid` 
    FROM `products` p 
    WHERE `p`.`id` IN (
    	SELECT 
    		`product_id` 
    	FROM `product_category`
        WHERE `category_id` IN (&#39;223&#39;, &#39;15&#39;)
    )
    AND `p`.`active`=1

I could also do this with a join, but I need this format for performance.

Content Type	Original Author	Original Content on Stackoverflow
Question	srinivasankanna	View Question on Stackoverflow
Solution 1 - Mysql	imulsion	View Answer on Stackoverflow

How do I create a user with the same privileges as root in MySQL/MariaDB?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Debugging Package Manager Console Update-Database Seed Method

Problems with lib-icu dependency when installing Symfony 2.3.x via Composer

Attributions