[Ilugc] error in installing mysql in ubuntu ?
hi to all i did not find this doubt in google so i raised this question here am new to ubuntu linux for the pest few years i using only windows ERROR 1045 (28000): Access denied for user 'pa1'@'localhost' (using password: NO) what is this problem states and how to overcome this type of errors in terminal i need to install mysql and need to run how to overcome this ? i request to ilug to conduct free seminars for basic commands and how to go through in lunix and how to installation and how to operate , for windows users ? normally iam dummie person in linux not even know anything in linux . thank u ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
[Ilugc] error in installing mysql in ubuntu ?
i installed mysql in ubuntu ERROR 1045 (28000): Access denied for user 'pa1'@'localhost' (using password: NO) after i entered this command "mysql -u pa1 -p" after entering my password the error stating that ERROR 1045 (28000):Access denied for user 'pa1'@'localhost' (using password: YES) for this i did not found answer in google can please solve this issue i tried in all the ways but i did not go through correctly please help me to solve this issue ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] error in installing mysql in ubuntu ?
Hi, On Sun, May 9, 2010 at 11:31 AM, jaya kumar wrote: > ERROR 1045 (28000): Access denied for user 'pa1'@'localhost' (using > password: NO) > Well, looks like you need a password to log in! Try: "mysql -u pa1 -p", and enter the password you have set for user 'pa1'. > i request to ilug to conduct free seminars for basic commands and how to > go > through in lunix and how to installation and how to operate , for windows > users ? > Why don't you learn the same by yourself? The last thing anyone in this list wants to do is to spoon feed :) http://www.google.co.in/search?q=basic+commands+linux http://www.google.co.in/search?q=how+to+install+software+in+linux http://www.google.co.in/search?q=how+to+use+mysql+in+linux Try the first three links in each of the search results, you'll get whatever you need. -- Thanks and Regards, Hrishikesh Murali ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] error in installing mysql in ubuntu ?
Hi, On Mon, May 10, 2010 at 9:46 PM, jaya kumar wrote: > ERROR 1045 (28000):Access denied for user 'pa1'@'localhost' (using > password: > YES) > Well, I guess user 'pa1' doesn't exist in mysql. Create a user 'pa1', set a password and log in. http://dev.mysql.com/doc/refman/5.1/en/adding-users.html -- Thanks and Regards, Hrishikesh Murali ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] error in installing mysql in ubuntu ?
On Mon, May 10, 2010 at 10:05 PM, Hrishikesh Murali < hrishikeshmural...@gmail.com> wrote: > Hi, > > On Mon, May 10, 2010 at 9:46 PM, jaya kumar >wrote: > > > ERROR 1045 (28000):Access denied for user 'pa1'@'localhost' (using > > password: > > YES) > > > By default MySQL would have only one user account called 'root' with out any password protection. The password is empty string until you mention the password explicitly during the installation. 1. Login to mysql using root account 2. Create new user account in MySQL 3. Grant required privilege to the user. -- Ravi Jaya Mobile: +91 97909 16181 ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
Re: [Ilugc] error in installing mysql in ubuntu ?
Hi, > > ERROR 1045 (28000):Access denied for user 'pa1'@'localhost' (using > > > password: > > > YES) > > 1. Login to mysql using root account > 2. Create new user account in MySQL > 3. Grant required privilege to the user. > > > 1. Login to mysql using root account $ mysql -u root -p mysql Enter password:[enter the password, nothing will be displayed ,not even asterisks] mysql> 2. Create new user account in MySQL mysql>CREATE USER 'pa1'@'localhost' IDENTIFIED BY 'some_pass'; 3. Grant required privilege to the user. mysql>grant all on *.* to 'pa1'@'localhost' identified by 'some_pass'; mysql>grant all on *.* to 'pa1'@'%' identified by 'some_pass'; ref manual for selective grant options. 4. get out of mysql mysql>exit 5. enter into mysql with the new user which has been created $ mysql -u pa -p Enter password 6.Entering right password ,Bingo , you are in mysql> My take is that ,ensure you have entered right password. HTH, Cheers, Thyagarajan Shanmugham ___ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc