Error in mysql connectivity with netbeans while creating database?

Question

i am using xampp.i want to connect mysql with netbeans.i tested my connection while creating new connection from database in services tab.i get the connection successful message.but while trying to create a database i get this error

access denied for user"@'localhost' to database 'student'

sounds like a permissions issue. do you have create permissions? — Rachel Gallen
– Rachel Gallen, Commented Feb 15, 2013 at 18:18
if it's sqllite you have to go into the database and update them aswell as updating the sqllite file — Rachel Gallen
– Rachel Gallen, Commented Feb 15, 2013 at 18:25
mysql database.is there something i did not know about this types?if yes please help. — user1870724
– user1870724, Commented Feb 15, 2013 at 18:35

Rachel Gallen · Accepted Answer · 2013-02-15 18:46:58Z

2

for mysql

Revoke privileges

revoke all privileges on *.* from 'student'@'localhost';

Then grant the appropriate privileges as desired:

grant SELECT,INSERT,UPDATE,DELETE ON `db`.* TO 'student'@'localhost';

in your case you may want

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

Finally, flush:

    flush privileges;

edited Feb 15, 2013 at 18:46

answered Feb 15, 2013 at 18:34

Rachel Gallen

28.7k22 gold badges77 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

user1870724 Over a year ago

i cant create a database and what should i be specifying in db.* ?

Rachel Gallen Over a year ago

Grant all should work for creating db - the second one - don't specify a database if you have . it'll grant you privileges on everything

user1870724 Over a year ago

I got it.After executing grant i got a message as "query ok.0 rows affected".Is that ok?

Rachel Gallen Over a year ago

you might have to start again i.e. revoke, grant and flush

user1870724 Over a year ago

Thanks a lot!in cmd if i execute the command create database it is successful.but in netbeans i still cant create a new database by right clicking on the mysql Server @ localhost.the same access denied error is shown?

|

Collectives™ on Stack Overflow

Error in mysql connectivity with netbeans while creating database?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related