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
15 43511
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:
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
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 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.
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.
hi,
I had type command given by you...... and result is........
[root@localhost mydb]# rpm -q mysql
package mysql is not installed
thanyou
-raju
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
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?
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
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
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
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
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 -
chkconfig mysqld --level 345 on
-
Restart mysql daemon
Check mysql daemon status
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.
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" -
-
mysql> USE test;
-
Reading table information for completion of table and column names
-
You can turn off this feature to get a quicker startup with -A
-
-
Database changed
-
-
Now i am using sql command.
-Thanq Mr.sashi
Raju
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" -
-
mysql> USE test;
-
Reading table information for completion of table and column names
-
You can turn off this feature to get a quicker startup with -A
-
-
Database changed
-
-
Now i am using sql command.
-Thanq Mr.sashi
Raju
Hi Raju,
Good luck with your experiment, take care.
Sign in to post your reply or Sign up for a free account.
Similar topics
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>...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
|
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...
| |