473,327 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

mysqladmin: connect to server at 'localhost' failed - MySQL

58
hi all,

I got the error like
[sait6@localhost treestructure]$ mysqladmin -h localhost -u root -p create bedrock
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

[sait6@localhost treestructure]$ mysqladmin --no-defaults -u root ver
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'


and when i type mysql and start to change some password i got

mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','sait6','sait123');
ERROR 1046 (3D000): No database selected

please give suggestion to eradicate the above problem.

thanyou.
-RAJU
Nov 9 '06 #1
15 43511
ronverdonk
4,258 Expert 4TB
hi all,

I got the error like
[sait6@localhost treestructure]$ mysqladmin -h localhost -u root -p create bedrock
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

[sait6@localhost treestructure]$ mysqladmin --no-defaults -u root ver
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'


and when i type mysql and start to change some password i got

mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','sait6','sait123');
ERROR 1046 (3D000): No database selected

please give suggestion to eradicate the above problem.

thanyou.
-RAJU
In the first case you obviously eneterd an incorrect password.
The second case failed because you need a password.
Case three: did you enter the 'use database;' command before the insert command?

Ronald :cool:
Nov 9 '06 #2
rajbala
58
In the first case you obviously eneterd an incorrect password.
The second case failed because you need a password.
Case three: did you enter the 'use database;' command before the insert command?

Ronald :cool:
hi,
tankQ.But i had checked each and every one.
I never set any password. If it is case i set the default password also.
same error.

now i has new a error.

[root@localhost sait6]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I am in starting stage for instaling the sql.
ThankQ
-raju
Nov 9 '06 #3
rajbala
58
hi all,
now i got the new problem...... I want to explained from first .....
I download :

MySQL-server-5.0.24a-0.glibc23.i386.rpm
MySQL-client-5.0.24a-0.glibc23.i386.rpm

I start installing in terminal...

[root@localhost mydb]# rpm -ivh MySQL-server-5.0.24a-0.glibc23.i386.rpm
MySQL-client-5.0.24a-0.glibc23.i386.rpm

After this command it just hang up:
now i pressed cntrl+z

I got
[2]+ Stopped rpm -ivh
MySQL-server-5.0.24a-0.glibc23.i386.rpm
MySQL-client-5.0.24a-0.glibc23.i386.rpm

I dont why at starting itself it hanging up.
please give suggestion for my problem.

ThanQ

-Raju
Nov 13 '06 #4
sashi
1,754 Expert 1GB
hi all,
now i got the new problem...... I want to explained from first .....
I download :

MySQL-server-5.0.24a-0.glibc23.i386.rpm
MySQL-client-5.0.24a-0.glibc23.i386.rpm

I start installing in terminal...

[root@localhost mydb]# rpm -ivh MySQL-server-5.0.24a-0.glibc23.i386.rpm
MySQL-client-5.0.24a-0.glibc23.i386.rpm

After this command it just hang up:
now i pressed cntrl+z

I got
[2]+ Stopped rpm -ivh
MySQL-server-5.0.24a-0.glibc23.i386.rpm
MySQL-client-5.0.24a-0.glibc23.i386.rpm

I dont why at starting itself it hanging up.
please give suggestion for my problem.

ThanQ

-Raju
Hi there,

Please type the below command to list all the MySQL related packages installed on your machine. Please post the output on your next post. Good luck & take care.

Expand|Select|Wrap|Line Numbers
  1.   rpm -q mysql
  2.  
Nov 13 '06 #5
rajbala
58
Hi there,

Please type the below command to list all the MySQL related packages installed on your machine. Please post the output on your next post. Good luck & take care.

Expand|Select|Wrap|Line Numbers
  1.   rpm -q mysql
  2.  
hi,
I had type command given by you...... and result is........

[root@localhost mydb]# rpm -q mysql
package mysql is not installed

thanyou
-raju
Nov 14 '06 #6
rajbala
58
Hi sashi,
still i can't able to instal sql to my PC.please help me.
thanQ
-raju

hi,
I had type command given by you...... and result is........

[root@localhost mydb]# rpm -q mysql
package mysql is not installed

thanyou
-raju
Nov 17 '06 #7
bartonc
6,596 Expert 4TB
Hi sashi,
still i can't able to instal sql to my PC.please help me.
thanQ
-raju
If this is a windows machine, you should get the .msi and let it do the work of installing. What is your OS, anyway?
Nov 17 '06 #8
sashi
1,754 Expert 1GB
If this is a windows machine, you should get the .msi and let it do the work of installing. What is your OS, anyway?
Hi Bartnoc,

Raju is on Linux box, I suspect that he did not select/install the mysql-devel package during his initial Linux installation.

[root@localhost mydb]# rpm -ivh MySQL-server-5.0.24a-0.glibc23.i386.rpm
Nov 19 '06 #9
rajbala
58
Hi Bartnoc,

Raju is on Linux box, I suspect that he did not select/install the mysql-devel package during his initial Linux installation.
hi,
I again instal the sql I got the same error.....

[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Suggest me for above problem.
ThankQ
-Raju
Nov 20 '06 #10
sashi
1,754 Expert 1GB
hi,
I again instal the sql I got the same error.....

[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Suggest me for above problem.
ThankQ
-Raju
Hi Raju,

I was just wondering about why you need to use mysqladmin? Creating new database or what? Instead you can use mysql. You don't need to include any password with the above command as you have not changed the mysql initial password.

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

http://coronet.iicm.edu/mysql/create.html
Nov 20 '06 #11
rajbala
58
Hi Raju,

I was just wondering about why you need to use mysqladmin? Creating new database or what? Instead you can use mysql. You don't need to include any password with the above command as you have not changed the mysql initial password.

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

http://coronet.iicm.edu/mysql/create.html
Hi sashi,
Ok i am not stick on mysqladmin.
As per link i tried. See the below commands which i used.

[sait6@localhost mydb]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.24a-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

mysql> CREATE DATABASE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Please suggest me nex what i can do...
ThanQ for the link.
-raju
Nov 20 '06 #12
sashi
1,754 Expert 1GB
Hi sashi,
Ok i am not stick on mysqladmin.
As per link i tried. See the below commands which i used.

[sait6@localhost mydb]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.24a-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

mysql> CREATE DATABASE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Please suggest me nex what i can do...
ThanQ for the link.
-raju
Hi Raju,

I think i know the reason for this error, MySQL daemon is only started upon request, instead it can be started at boot time itself. Kindly issue the following command, hope it helps. Good luck & Take care.

Use chkconfig to set the runlevel preferences
Expand|Select|Wrap|Line Numbers
  1.   chkconfig mysqld --level 345 on
  2.  
Restart mysql daemon
Expand|Select|Wrap|Line Numbers
  1.   service mysqld restart
  2.  
Check mysql daemon status
Expand|Select|Wrap|Line Numbers
  1.   service mysqld status
  2.  
Nov 20 '06 #13
sashi
1,754 Expert 1GB
Hi sashi,
Ok i am not stick on mysqladmin.
As per link i tried. See the below commands which i used.

[sait6@localhost mydb]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.24a-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

mysql> CREATE DATABASE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Please suggest me nex what i can do...
ThanQ for the link.
-raju
Hi Raju,

Wait a second, are you accesing MySQL as user root? Does this user "saitxyz" have access to use any database on the server? Please check these details.
Nov 20 '06 #14
rajbala
58
Hi Raju,
Wait a second, are you accesing MySQL as user root? Does this user "saitxyz" have access to use any database on the server? Please check these details.
Hi sashi,
I had checked Thankyou for sugesstion alot and very lot.
Because I got it.

Instead of using the database of "mysql" i had use "test"

Expand|Select|Wrap|Line Numbers
  1.  
  2. mysql> USE test;
  3. Reading table information for completion of table and column names
  4. You can turn off this feature to get a quicker startup with -A
  5.  
  6. Database changed
  7.  
  8.  
Now i am using sql command.
-Thanq Mr.sashi

Raju
Nov 21 '06 #15
sashi
1,754 Expert 1GB
Hi sashi,
I had checked Thankyou for sugesstion alot and very lot.
Because I got it.

Instead of using the database of "mysql" i had use "test"

Expand|Select|Wrap|Line Numbers
  1.  
  2. mysql> USE test;
  3. Reading table information for completion of table and column names
  4. You can turn off this feature to get a quicker startup with -A
  5.  
  6. Database changed
  7.  
  8.  
Now i am using sql command.
-Thanq Mr.sashi

Raju
Hi Raju,

Good luck with your experiment, take care.
Nov 21 '06 #16

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Krista | last post by:
Hi, I hope you guys can help me out~~~ when I run it localhost/config.php, it cannot display any message such as connect successfully or failed. Do u guys have any idea? config.php <html>...
3
by: Krista | last post by:
Hi, Hope you guys can help me out~~ I have a config.php file. I want to conncet to my own mysql version. When i run the config.php file as below, i get all successful message. However, when i take...
0
by: Saravanan Kulandaivelu | last post by:
--------------B23FB769A9677B05B30099D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am getting the following error: mysqladmin: connect to server at...
0
by: Randell D. | last post by:
Folks, I've been using MySQL 3.23 for a number of months - I've got familiar with the everyday stuff (read/write/sort) but access or grant management still remains foreign. After a recent...
16
by: MLH | last post by:
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my...
1
by: rajbala | last post by:
hi all, I got the error like $ mysqladmin -h localhost -u root -p create bedrock Enter password: ****** mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user...
1
by: iceboy | last post by:
Hello to all,I have a problem to connect PHP & MySQL together. I have created a form that gets the username & password from admin and connect him to database.the part of PHP script that connect to...
5
by: suma | last post by:
hi to all plaese help me i have same problem when download the phpdev and phptriad i cant connect to mysql when click the MyAdmin apear this messege in the page 'Warning: MySQL Connection...
5
by: lisles | last post by:
i have a page funtion.php which hs the function to connect to the db /* Mysql Connection */ function connect(){ global $db_server,$db_user,$db_pass,$db;//Global Values from the config.php...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.