Connect to mysql server without sudo

by

Only the root user needs sudo requirement to login to mysql. I resolved this by creating a new user and granting access to the required databases:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';

now newuser can login without sudo requirement:

mysql -u newuser -p

More Related Contents:

  1. Delete the entire content of all table in a Database [closed]
  2. MyISAM versus InnoDB [closed]
  3. Calculate a running total in MySQL
  4. How do I find the MySQL my.cnf location
  5. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  6. How to change MySQL data directory?
  7. MySQL Syntax error message “Operand should contain 1 column(s)”
  8. How to use mysql JOIN without ON condition?
  9. Format number to 2 decimal places
  10. How to remove all non-alpha numeric characters from a string in MySQL?
  11. INSERT … ON DUPLICATE KEY (do nothing)
  12. Define a variable within select and use it within the same select
  13. How to remove new line characters from data rows in mysql?
  14. ERROR: Error 1005: Can’t create table (errno: 121)
  15. Merge two tables in one SQL query and make the date values unique
  16. mySQL subquery limit
  17. How to increase MySQL connections(max_connections)?
  18. COUNT(*) from multiple tables in MySQL
  19. libmysqlclient15-dev on macs?
  20. Laravel Eloquent group by most recent record
  21. Are SELECT type queries the only type that can be nested?
  22. I keep getting this mysql error code #1089
  23. How to grant remote access to MySQL for a whole subnet?
  24. How to drop all tables from the database with manage.py CLI in Django?
  25. Database returned an invalid value in QuerySet.dates()
  26. Access to mysql container from other container
  27. CAST to DECIMAL in MySQL
  28. How can I rebuild indexes and update stats in MySQL innoDB?
  29. mysql – move rows from one table to another
  30. #1214 – The used table type doesn’t support FULLTEXT indexes

Leave a Comment