i was using mysql to connect to database in java. but it is throwing an error that is" access denied for use' '@'localhost' to database 'onlinetest'
while installing mysql I DIDNT PROVIDED ANY USERNAME AND PASSWORD, IS THERE ANY PROBLEM WITH USER AND PASS AND WHAT TO WRITE IN USER AND PASS DURING CODING, IN JDBC
arshi9464 -2 Light Poster
sj5536 5 Junior Poster in Training
user name root
password ""
u have to give all privilege to all user in mysql
htmlCoder101 0 Newbie Poster
user name root
password ""
u have to give all privilege to all user in mysql
yep2, this is how you do it..
masijade 1,351 Industrious Poster Team Colleague Featured Poster
No it is not. You should read the mysql user manual (and pay close attention to the part about grants) and give the root login a password (or restrict it to only the unix socket connection), delete the "blank" user account, and create an application user for your application.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.