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
Post a Comment