Cannot use mysql in linux fedora14. Do we have to install it or the bydefault coming is fine.
-
Hi I have not installed mysql on my own, its the default one that is coming with fedora14 at /usr/local/mysql I am giving you some screenshots, please check if you can find out something. ********************************************************************************************************************************************************* The first issue is while I login using command mysql -u root -p it asks for password I enter, root123 then gives the error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) let me give you the full flow: I am using fedora 14 _________________________________________________________________________________________________________ in root I fire the below commands: [starting the mysql] [root@chandan init.d]# /etc/init.d/mysqld start Starting mysqld: [ OK ] now from my local account I try to login to sql, [chadan@chandan ~]$ mysql -u root -p Enter password: [i give password as root123 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) But when I login using command [chadan@chandan ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.51 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> [here I am able to login to server but when I try to create database then it gives error] mysql> create database dummy; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'dummy' mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ ********************************************************************************************************************************** NOW THE SECOND ISSUE WHEN I START THE SERVER IN DIFFERENT WAY. [root@chandan init.d]# mysqld_safe --skip-grant-tables & [1] 29006 [root@chandan init.d]# 110219 18:33:25 mysqld_safe Logging to '/var/log/mysqld.log'. 110219 18:33:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Now from my account I try to logi
-
Hi I have not installed mysql on my own, its the default one that is coming with fedora14 at /usr/local/mysql I am giving you some screenshots, please check if you can find out something. ********************************************************************************************************************************************************* The first issue is while I login using command mysql -u root -p it asks for password I enter, root123 then gives the error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) let me give you the full flow: I am using fedora 14 _________________________________________________________________________________________________________ in root I fire the below commands: [starting the mysql] [root@chandan init.d]# /etc/init.d/mysqld start Starting mysqld: [ OK ] now from my local account I try to login to sql, [chadan@chandan ~]$ mysql -u root -p Enter password: [i give password as root123 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) But when I login using command [chadan@chandan ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.51 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> [here I am able to login to server but when I try to create database then it gives error] mysql> create database dummy; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'dummy' mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ ********************************************************************************************************************************** NOW THE SECOND ISSUE WHEN I START THE SERVER IN DIFFERENT WAY. [root@chandan init.d]# mysqld_safe --skip-grant-tables & [1] 29006 [root@chandan init.d]# 110219 18:33:25 mysqld_safe Logging to '/var/log/mysqld.log'. 110219 18:33:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Now from my account I try to logi