blocks|key|1858460|text|如果您有密码设置，则为mysql+-u+root；如果没有，则为mysql+-u+root+-p+root。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1858461|这将提示输入root密码。无论如何，我总是使用mac终端。安装时，只需使用mysql即可登录，还可以设置root的密码。我还建议你阅读Creating+a+MySQL+user|1858462|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/create-user.html^0|B|D|W|L|0|6|4|11|5|1G|4|1V|L|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|H|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

<code>mysql -u root</code> if you have a password setup, or <code>mysql -u root -p root</code> if you don't.

This will prompt the <code>root</code> password.
I always use the mac terminal anyways. When you install, just using <code>mysql</code> you can log in, and you can setup the password for the <code>root</code>.
I also advice you to read <a href="http://dev.mysql.com/doc/refman/5.1/en/create-user.html" rel="nofollow">Creating a MySQL user</a>

blocks|key|1858474|text|在OSX终端提示符处，输入mysql+-u+root以实际启动连接到服务器的命令行客户端。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|1858475|shell>表示您的shell提示符的实际外观。|1858476|在命令行提示符下键入mysql后，请不要输入。|1858477|下面是一个会话示例：|1858478|shell>+mysql+-u+root
mysql>+SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('newpwd');
mysql>+SET+PASSWORD+FOR+'root'@'127.0.0.1'+=+PASSWORD('newpwd');
mysql>+SET+PASSWORD+FOR+'root'@'::1'+=+PASSWORD('newpwd');
mysql>+SET+PASSWORD+FOR+'root'@'host_name'+=+PASSWORD('newpwd');|code-block|syntax|javascript|1858479|1858480|注意:您可能需要在shell>+mysql+-u+root前面加上shell>+sudo+mysql+-u+root|blockquote|1858481|1858482|1858483|我的shell提示符被定制为在末尾带有一个\n的[jhr@Blackintosh]+[/usr/local/mysql-5.5.25a-osx10.6-x86_64/bin]，以便在下一行输入./mysql+-u+root它。其余的就是该命令应该输出的内容。shell提示符被mysql程序提示符替代。|1858484|下面是我的shell输出|1858485|[jhr@Blackintosh]+[/usr/local/mysql-5.5.25a-osx10.6-x86_64/bin]+
./mysql+-u+root
Welcome+to+the+MySQL+monitor.++Commands+end+with+;+or+\g.
Your+MySQL+connection+id+is+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.+Other+names+may+be+trademarks+of+their+respective
owners.

Type+'help;'+or+'\h'+for+help.+Type+'\c'+to+clear+the+current+input+statement.

mysql>+|1858486|entityMap^0|1|8|D|D|0|0|6|0|A|5|M|1|0|0|A|0|0|0|0|1M|9|K|X|P|0|0|0|0|47|L|2|O|1R|2O|F|3U|5|0|0|C|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|1A|8|@$9|1B|A|1C|B|D]]|E|@]|F|$]]|$1|I|3|J|5|6|7|1D|8|@$9|1E|A|1F|B|D]|$9|1G|A|1H|B|C]]|E|@]|F|$]]|$1|K|3|L|5|6|7|1I|8|@$9|1J|A|1K|B|C]]|E|@]|F|$]]|$1|M|3|N|5|O|7|1L|8|@]|E|@]|F|$P|Q]]|$1|R|3|-4|5|6|7|1M|8|@]|E|@]|F|$]]|$1|S|3|T|5|U|7|1N|8|@$9|1O|A|1P|B|C]|$9|1Q|A|1R|B|D]|$9|1S|A|1T|B|D]]|E|@]|F|$]]|$1|V|3|-4|5|6|7|1U|8|@]|E|@]|F|$]]|$1|W|3|-4|5|6|7|1V|8|@]|E|@]|F|$]]|$1|X|3|Y|5|6|7|1W|8|@$9|1X|A|1Y|B|C]|$9|1Z|A|20|B|D]|$9|21|A|22|B|D]|$9|23|A|24|B|D]|$9|25|A|26|B|D]]|E|@]|F|$]]|$1|Z|3|10|5|6|7|27|8|@$9|28|A|29|B|C]]|E|@]|F|$]]|$1|11|3|12|5|O|7|2A|8|@]|E|@]|F|$P|Q]]|$1|13|3|-4|5|6|7|2B|8|@]|E|@]|F|$]]]|14|$]]

At the OSX Terminal prompt you enter <code>mysql -u root</code> to actually start the command line client that connects to the server.

<code>shell&gt;</code> represents whatever your shell prompt actually looks like.

You do not enter this in after you have already typed <code>mysql</code> at the command line prompt.

Here is an example session:

<pre><code>shell&gt; mysql -u root
mysql&gt; SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql&gt; SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
mysql&gt; SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpwd');
mysql&gt; SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');
</code></pre>

<blockquote>
 NOTE: you might need to preface the <code>shell&gt; mysql -u root</code> with <code>shell&gt; sudo mysql -u root</code>
</blockquote>

My shell prompt is customized to be<code>[jhr@Blackintosh] [/usr/local/mysql-5.5.25a-osx10.6-x86_64/bin]</code> with a <code>\n</code> on the end so <code>./mysql -u root</code> it typed at the on the next line down. The rest is what the output of that command should be. The shell prompt is replaced by the prompt of the <code>mysql</code> program prompt.

<h3>Here is what my shell output looks like</h3>

<pre><code>[jhr@Blackintosh] [/usr/local/mysql-5.5.25a-osx10.6-x86_64/bin] 
./mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 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. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql&gt; 
</code></pre>

blocks|key|3247728|text|当你第一次开始在mac上使用mysql时，所有的账户都没有密码，甚至连root都没有。因此，您可以使用超级用户登录而不使用密码，然后您必须按照Jarrod所解释的那样设置密码，或者更详细地阅读：http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3247729|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html^0|2P|1Q|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

When you first start using mysql on mac none of the accounts have passwords, not even root. So you can login with root and no password and then you must set passwords as explained by Jarrod, or for more detail read:
<a href="http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html</a>

blocks|key|3247748|text|执行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3247749|mysql+-u+root+-p|code-block|syntax|javascript|3247750|将在您的控制台上提示：|3247751|#:=>+Enter+password:+[enter+your+pass]|3247752|这样您就可以登录mysql+dbms|3247753|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Executing this command:

<pre><code>mysql -u root -p
</code></pre>

Will prompt on your console:

<pre><code>#:=&gt; Enter password: [enter your pass]
</code></pre>

That way you can login mysql dbms

blocks|key|3336566|text|我最近遇到了这个问题，并意识到我的登录路径是bin/bash，所以如果其他人有这个问题，这里是我如何解决它的。如果您安装了XAMPP，请转到您的应用程序文件夹，然后转到XAMPP文件夹。然后转到bin文件夹。如果您在bin文件夹中，这将是您使用以下命令的路径|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3336567|mysql+-uroot|code-block|syntax|javascript|3336568|现在打开您的终端应用程序，在左上角单击terminal，然后单击preferences。在显示"shell+open+with“的地方，选择默认选项，然后关闭终端窗口。现在重新打开它，您的终端应该像这样启动|3336569|+Last+login:+Mon+Dec+18+12:06:25+on+ttys
+[yourname]-air:~+[yourname]$+|3336570|现在输入路径|3336571|+/Applications/XAMPP/bin/mysql+-uroot|3336572|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

i was having this problem recently and realized my login path was bin/bash so incase anyone else has this problem heres how i fixed it. if you have XAMPP installed go to your applications folder then go to the XAMPP folder. then go to the bin folder. if you are in the bin folder, this will be your path to use the following command

<pre><code>mysql -uroot
</code></pre>

now open your terminal application and on the top left click on terminal and then preferences. where it says "shell open with", select the default option then close your terminal window. now reopen it and your terminal should start like this

<pre><code> Last login: Mon Dec 18 12:06:25 on ttys
 [yourname]-air:~ [yourname]$ 
</code></pre>

now type the path

<pre><code> /Applications/XAMPP/bin/mysql -uroot
</code></pre>

I've just set up MySQL on my computer (OS X 10.7), and it seems to be working, judging by the "mysqld" in the activity monitor and the new icon in my System Preferences.

However I'm having trouble doing anything with MySQL, as I need to login at least as the root user, but it doesn't let me. So let's run through what I've been doing and what error messages I'm getting:

Firstly, I start up MySQL via the "mysql" unix executable file. This seems to work, as my entries are now preceded with

<pre><code> mysql&gt; 
</code></pre>

Also, I can type

<pre><code> help;
</code></pre>

and I get MySQL's help list. So then I go to do something, like create a database:

<pre><code> CREATE DATABASE books;
</code></pre>

but I get the following error:

<pre><code> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'books'
</code></pre>

So then I figure I need to login, and that logging in as the root user should be enough. I enter the following:

<pre><code> mysql -u root -p;
</code></pre>

But I get the 1064 error saying my syntax is wrong. I've had a look around through a number of websites, and this never seems to be a problematic step. Any clues on what's going wrong for me?

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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我刚刚在我的电脑(OSX10.7)上设置了MySQL，从活动监视器中的"mysqld“和我的系统偏好设置中的新图标来判断，它似乎正常工作。然而，我在使用MySQL时遇到了问题，因为我至少需要作为根用户登录，但它不允许我这样做。因此，让我们来看看我一直在做什么，以及我收到了什么错误消息：首先，我通过" MySQL“uni...

问如何以超级用户身份登录OS X上的MySQL？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何以超级用户身份登录OS X上的MySQL？EN