My SQL 1045 error : couldn't create database
my sql server is runnin ok.
i m using suse distro. and i m logged in as root. whenever i give mysql command in terminal i prints Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) whenver i type mysql -u manniit prints Code:
Welcome to the MySQL monitor. Commands end with ; or \g. Code:
mysql> create database php; thanks |
Quote:
mysql -u root -p This will prompt for the root password. Quote:
The solution for the above is to login as root and give database creation privileges to the user. -- Prasanta |
All times are GMT -5. The time now is 01:54 AM. |