Windows command line connect remote mysql server

Cornea Valentin Cornea Valentin 3 3 silver badges 10 10 bronze badges. The best answer! Thanks — Nastro. It's possible that you don't allow remote connections.

On your local machine, create the tunnel. How do I forward multiple ports to different servers at the same time? My use case -- we have several production Wordpress servers that are behind a firewall. Also assume that each of them uses a different SSH key to allow access. There is simple command. Manish Goswami Manish Goswami 2 2 silver badges 9 9 bronze badges. Must check whether incoming access to port is block or not by the firewall.

Amirol Ahmad Amirol Ahmad 5 5 silver badges 19 19 bronze badges. How can I check this — ChandraMouli Poreddy. Hope this helps. You should put your password with 'p' mysql -u root -u 1.

Karin Lahyani Karin Lahyani 1 1 silver badge 5 5 bronze badges. Davinder Snehi Davinder Snehi 1 2 2 bronze badges. Arun Panneerselvam Arun Panneerselvam 1, 1 1 gold badge 15 15 silver badges 21 21 bronze badges. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Visit chat. Linked See more linked questions. On some systems, the library routine that MySQL uses to prompt for a password automatically limits the password to eight characters. That limitation is a property of the system library, not MySQL. Internally, MySQL does not have any limit for the length of the password.

To work around the limitation on systems affected by it, specify your password in an option file see Section 4. Another workaround is to change your MySQL password to a value that has eight or fewer characters, but that has the disadvantage that shorter passwords tend to be less secure. If the host is not specified or is localhost , a connection to the local host occurs:. On Unix, MySQL programs treat the host name localhost specially, in a way that is likely different from what you expect compared to other network-based programs: the client connects using a Unix socket file.

On Windows, if host is. The --protocol option enables you to use a particular transport protocol even when other options normally result in use of a different protocol. That is, --protocol specifies the transport protocol explicitly and overrides the preceding rules, even for localhost.

Only connection options that are relevant to the selected transport protocol are used or checked. Other connection options are ignored.

See Section 5. Use the --socket option to specify the name of the pipe if you do not want to use the default pipe name. This command connects to the server running on remote. To specify a port number explicitly, use the --port or -P option:. You can specify a port number for connections to a local server, too. For this command, the program uses a socket file on Unix and the --port option is ignored:.

For example, invoke the program in either of these ways:. For additional information about options that control how client programs establish connections to the server, see Section 4. It is possible to specify connection parameters without entering them on the command line each time you invoke a client program:. If you have trouble connecting, repeat these steps above, making sure to create a new outbound rule in your firewall settings using the same details port , etc.

You may also need to configure your local network router to open the necessary blocked ports to allow inbound and outbound connections to your database. You can do this using the mysql command mysql. Mac users can install MySQL using homebrew from the terminal brew install mysql , while Linux users can use their local app repository eg.

You can then create a suitable user account by following the steps below. As this level of access is unsafe, you may prefer to create a more restricted account for accessing your MySQL database. This account will have limited access to your MySQL server, allowing it to interact with only selected databases.

With access granted, use the steps in the section above to connect to your server remotely using your new account eg. X:XXXX -p. A good way to do this is to generate SSH keys for remote access to your server, rather than relying on outdated and easily guessable passwords. Most databases are run using Linux servers—you can automate a Linux file backup easily.

Ben Stockton is a freelance technology writer based in the United Kingdom. In a past life, Ben was a college lecturer in the UK, training teens and adults.