C: / mysql / bin> mysql -u root -p1111 for your password
You can log in to mysql using the root user. Refer to the following command
Quote: Grant All on dbname. * To 'user' @ '%' Identified by 'Passwd'
All represents all permissions, such as SELECT, INSERT, DELETE, and more. DBNAME represents the database name. User user name% represents this user from any IP address. Passwd represents the password.