search

sqlectron / sqlectron-gui

A simple and lightweight SQL client desktop with cross database and platform support.
https://sqlectron.github.io/
MIT License
4.57k stars 524 forks source link

Ilija #417

Closed IlijaZubac closed 6 years ago

IlijaZubac commented 6 years ago

Sorry, but I'm new in this. I was install sqlelectron, and I have a problem which result with this message: code: ER_DBACCESS_DENIED_ERROR errno: 1044 sqlMessage: Access denied for user ''@'localhost' to database 'information_schema' sqlState: 42000 sql: create table nova_tabela; name: Error I was install V 1.28 on PC/Windows 10 and when I put test connection without users and password that is pass, but after that, when I want to execute command, I get this message! Please help me.

maxcnunes commented 6 years ago

So, you are able to connect to a server. But is not able to execute any command in that? Even select and insert commands or just create table is not working?

IlijaZubac commented 6 years ago

Yes, thats true! It's the same when I tray to create database, I always get this message.

maxcnunes commented 6 years ago

If select and insert queries are working. But create table and create database are not. It seems a permission issue.

IlijaZubac commented 6 years ago

How do I solve that issue?

maxcnunes commented 6 years ago

This should give all the privileges available

GRANT ALL PRIVILEGES ON * . * TO 'YOUR_DB_USERNAME_HERE'@'localhost';

Source: https://askubuntu.com/questions/461064/unable-to-create-database-due-access-denied

Closing it since it is not a Sqlectron issue.