我如何使用Xampp从Mac终端访问mysql? [英] How do i access mysql from mac terminal, using xampp?

问题描述

我正在尝试从Mac的终端访问mysql.

I am trying to access mysql from my mac's terminal.

我尝试只输入

mysql -u根-p

mysql -u root -p

(和Enter键，但不存在.)

(and Enter, but that does not exist..)

到目前为止，这是我设法做到/定位的:

This is what i have managed to do/located so far:

Williams-iMac:mysql noName $ cd/Applications/xampp/xamppfiles/var/mysql/mysql

Williams-iMac:mysql noName$ cd /Applications/xampp/xamppfiles/var/mysql/mysql

Williams-iMac:mysql noName $ ls

Williams-iMac:mysql noName$ ls

这是那里的东西.

columns_priv.MYD        help_relation.frm       slow_log.CSV
columns_priv.MYI        help_topic.MYD          slow_log.frm
columns_priv.frm        help_topic.MYI          tables_priv.MYD
db.MYD              help_topic.frm          tables_priv.MYI
db.MYI              host.MYD            tables_priv.frm
db.frm              host.MYI            time_zone.MYD
event.MYD           host.frm            time_zone.MYI
event.MYI           ndb_binlog_index.MYD        time_zone.frm
event.frm           ndb_binlog_index.MYI        time_zone_leap_second.MYD
func.MYD            ndb_binlog_index.frm        time_zone_leap_second.MYI
func.MYI            plugin.MYD          time_zone_leap_second.frm
func.frm            plugin.MYI          time_zone_name.MYD
general_log.CSM         plugin.frm          time_zone_name.MYI
general_log.CSV         proc.MYD            time_zone_name.frm
general_log.frm         proc.MYI            time_zone_transition.MYD
help_category.MYD       proc.frm            time_zone_transition.MYI
help_category.MYI       procs_priv.MYD          time_zone_transition.frm
help_category.frm       procs_priv.MYI          time_zone_transition_type.MYD
help_keyword.MYD        procs_priv.frm          time_zone_transition_type.MYI
help_keyword.MYI        servers.MYD         time_zone_transition_type.frm
help_keyword.frm        servers.MYI         user.MYD
help_relation.MYD       servers.frm         user.MYI
help_relation.MYI       slow_log.CSM            user.frm

但是我仍然不知道如何访问mysql，这样我就可以创建一个新的数据库(不用phpmyadmin就能做到).我虽然在phpmyadmin中创建了一个新数据库，只是尝试输入:

But i still don't know how to access the mysql, so that i can create a new database (without doing it i phpmyadmin). I have created a new database in phpmyadmin though, just to try enter:

mysql -u root -p(my_phpmyadmin_created_database)

mysql -u root -p (my_phpmyadmin_created_database)

..但没有成功.

我希望我能将所有有关我的问题的信息提供给大家，希望有人能帮助我解决这个无聊的时间消耗问题！ :)

I hope that with all the information i have given about my issue to all of you out there, that someone will help my get by this time-consumimng-heck-of-a-boring-issue! :)

提前谢谢！

/W

推荐答案

/Applications/xampp/xamppfiles/bin/mysql -u root -p

/Applications/xampp/xamppfiles/bin/mysql -u root -p

像魅力一样工作！

感谢用户:Wrikken！

Thanks to user: Wrikken!

这篇关于我如何使用Xampp从Mac终端访问mysql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！