Adding MySQL Users By admin on February 23, 2005 in MySQL Here’s the syntax to add a user to MySQL: <pre class="code"> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; <pre class="code"> 1234 <pre class="code">GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;<pre class="code"> Related posts: Mysql Password Recovery