mysql - Remote db connection issues -


i trying log mysql using ssh using command:

mysql -u username -p -h hostname 

where 'username' , 'hostname' , placeholders real params. however, above gives error :

error 1045 (28000): access denied user 'username'@'vps-xxxxxx.xxxx.com' (using password: yes) 

why appending "@vps-xx...." remote server username?

place on root

grant privileges on *.* 'username'@'ip' identified 'password' grant options; 

privileges provided mysql

once have finalized permissions want set new users, sure reload privileges.

flush privileges; 

how grant different user permissions

here short list of other common possible permissions users can enjoy.

  1. all privileges- saw previously, allow mysql user access designated database (or if no database selected, across system)
  2. create- allows them create new tables or databases
  3. drop- allows them them delete tables or databases
  4. delete- allows them delete rows tables
  5. insert- allows them insert rows tables
  6. select- allows them use select command read through databases
  7. update- allow them update table rows
  8. grant option- allows them grant or remove other users' privileges

Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -