Turn off all Firewall Rules on Computer A. (Make sure you have mysql setup as an environmental variable otherwise Command Prompt won't understand the "mysql" command) mysql -host=192.168.11.1 -user=username -password=password If you can't connect, check Computer A's firewall's inbound rules and check if the MySQL Service is running on Computer A. Type in the following and you should be connected to Computer A. Then go to Computer B and open your Command Prompt/Terminal. GRANT ALL PRIVILEGES ON databasename.* TO don't understand why u used "***" as your password so I replaced it with 'password'. Then do your original commands again: CREATE USER IDENTIFIED BY 'password' So do these commands: DROP User User if you see user, also drop/delete that row. Then connect to the database, you will first need to create connection object with createConnection () which you’ll be able to pass database server url, credential and database name. It looks like you're trying to make a new user by the name of but a different user by the name of is getting in the way/taking precedence.ĭo this command to see the users: SELECT user,host FROM er To connect with the database, first you’ll have to install MySQL module via npm first. IPv4= 192.168.11.1Ĭomputer B= Has an Eclipse program that wants to connect to Computer A and do stuff to the schemas. What am I missing? Have I forgotten to do something or what else can I check?Ĭomputer A = Holds the MySQL DB. I use Sqlectron in Windows, so I want to install this IDE now in my Linux computer. I am using Manjaro Linux and so install my packages from the AUR. I have some other remote accounts on the same server and none of them have as they only connect locally. I'm a new Linux user and I want to install a MySQL IDE. I would like to create a local SQL Server instance on the machine, and then use SQLectron as a GUI client for querying my database. What’s new in version 1.38. I am also passionate about teaching and mentoring people from non-tech backgrounds who are under-represented in the industry. It is an open source project and any kind of contribution is welcome. I have done "flush privileges" but I still cannot connect - I notice that the error is and I don't have any permissions set up for but I have never had to do this before. Sqlectron is a simple and lightweight SQL client desktop/terminal with cross database and platform support. On the remote server I then use: mysql -u username -p DB_SERVER_IPĪnd get the error message: ERROR 1045 (28000): Access denied for user (using password: YES) | GRANT ALL PRIVILEGES ON `databasename`.* TO rows in set (0.00 sec) | Grants for GRANT USAGE ON *.* TO IDENTIFIED BY PASSWORD '***' Then I gave permissions: GRANT ALL PRIVILEGES ON databasename.* to user table on MySQL server shows (amongst other things): +-+-+ I added the user by: CREATE USER IDENTIFIED BY '***' I am setting up a remote connection to a MySQL server but no matter what I try I am getting access denied error from the remote server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |