MySQL Forums
Forum List  »  Install & Repo

Re: Connecting to mySql from Parallels
Posted by: Barry Galbraith
Date: March 28, 2014 09:57PM

In you Mac, open a terminal window(?) and start mysql commandline as root

$>mysql -uroot -p
enter root's password when prompted.
The create a user
GRANT ALL ON *.* to 'username'@'10.211.xxx.xxx' IDENTIFIED BY user_password;
FLUSH PRIVILEGES;

Or grant only the required privileges on the required database(s).
see the refman for user administration.
http://dev.mysql.com/doc/refman/5.6/en/user-account-management.html

You should then be able to connect to MySQL on your MAC from parallels like this on your parallels application

mysql -u username -h 192.168.0.xxx -p
enter username's password (user_password ?) when prompted.

This assumes that if there is a firewall between parallels and your mac os, that you have opened port 3306 for tcp traffic from 10.211.xxx.xxx

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Connecting to mySql from Parallels
March 28, 2014 09:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.