osx - How do I login as root on MySQL on OS X? -


I have just set up MySQL on my computer (OS X 10.7), and it seems that working, in Activity Monitor New icon "mysqld" and in my system preference

However, I am having trouble doing anything with MySQL, because I have to enter at least a root user, but do not let me go then let's go, what do I do I am getting and I get the error message:

First of all, I start MySQL through the "MySQL" Unix executable file. It starts to work, because my entries are now

  mysql>   

In addition, I can type

  support;   

And I get mysql help list Then I want to do something like creating a database:

  create a database;   

But I get the following error:

  Error 1044 (42000): User '' @ 'localhost' to database 'books' / code> / Pre> 

Then I think I need to enter, and that entering the root user should be enough. I enter the following:

  mysql -u root -p;   

But I get a 1064 error which says my syntax is incorrect. I get a look through many websites, and it never seems to be a problematic step.

Any clue on OSX terminal prompt ? You actually connect the command line client to the server to enter mysql -u root .

You have typed no after after you typed mysql at the command-line prompt.

Here is an example session:

  shell & gt; Mysql -u root mysql & gt; Set password for 'root' @ 'localhost' = password ('newpwd'); Mysql & gt; Password set for 'root' @ 127.0.0.1 '= password (' newness'); Mysql & gt; Set password for 'root' @: '::' 1 '= password (' newness'); Mysql & gt; Set password for 'root' @ 'host_name' = password ('newpwd');   

Note: gives you the shell & gt; Mysql -u route with open> Sudo mysql -u root

shell> represents whatever your shell prompt actually looks.

My shell output looks here
  [jhr@blickintosh] [/usr/local/mysql-5.5.25a-osx10.6-x86_64/bin] ./ Welcome to mysql -u Root MySQL Monitor Finished with order; Or your MySQL connection ID 5 server version: 5.5.25a MySQL Community Server (GPL) Copyright (C) 2000, 2011, Oracle and / or its affiliates All rights reserved. Oracle is a registered trademark of Oracle Corporation and / or its affiliates names may be trademarks of their respective owners. Type 'help;' Or '\ c' to clear the current input statement for help, type '\ c' mysql & gt;   

My shell prompt has been optimized as [jhr @Blinkintosh] [/usr/local/mysql-5.5.25a-osx10.6-x86_64/bin] Therefore ./ mysql -u root should be produced in the remaining command typed at the shell prompt. Shell prompt is replaced by the mysql program prompt.

Comments