473,387 Members | 1,578 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,387 software developers and data experts.

Can't connect from localhost with 4.1.1 alpha

I can connect from SQLYog,MySqlCC,jdbc from remote with no problem.
However, when I try to connect(mysql -u root) from localhost, then I
get access denied. Checked the user table and root can connect from
anywhere(%).

I am running 4.1.1 alpha on Red Hat with the --old-password option.
TIA.

sow
Jul 19 '05 #1
3 1748
br**********@optdatainc.com (sowbug) wrote in message news:<e5**************************@posting.google. com>...
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem.
However, when I try to connect(mysql -u root) from localhost, then I
get access denied. Checked the user table and root can connect from
anywhere(%).

I am running 4.1.1 alpha on Red Hat with the --old-password option.
TIA.

sow


Resolve: mysql -u root -proot

What happened to asking for a password?? and why no space after -p;
Come on, let's get the easy default stuff straight before worrying
about subselects and the like.
Jul 19 '05 #2
br**********@optdatainc.com (sowbug) wrote in message news:<e5**************************@posting.google. com>...
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem.
However, when I try to connect(mysql -u root) from localhost, then I
get access denied. Checked the user table and root can connect from
anywhere(%).

I am running 4.1.1 alpha on Red Hat with the --old-password option.
TIA.

sow


Resolve: mysql -u root -proot

What happened to asking for a password?? and why no space after -p;
Come on, let's get the easy default stuff straight before worrying
about subselects and the like.
Jul 19 '05 #3
br**********@optdatainc.com (sowbug) wrote in message news:<e5**************************@posting.google. com>...
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem.
However, when I try to connect(mysql -u root) from localhost, then I
get access denied. Checked the user table and root can connect from
anywhere(%).

I am running 4.1.1 alpha on Red Hat with the --old-password option.
TIA.

sow


Resolve: mysql -u root -proot

What happened to asking for a password?? and why no space after -p;
Come on, let's get the easy default stuff straight before worrying
about subselects and the like.
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Marc | last post by:
Hello, Newbie here..... Searching and working this for a week now. We too are having the same problems. Using MySql 4.0.14 and there are "no problems" at all.
0
by: leegold2 | last post by:
I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what am I overlooking? Again putting the...
0
by: Stefan Hinz | last post by:
Degan, jumping in to try and solve some problems that look pretty obvious to me ... > #options for default service (mysqld2) > (mysqld2) It should be , not (mysqld2).
2
by: Asad Khan | last post by:
Hello, I was using MySQL till a few days ago just fine. Now everytime I try to run it using mysql.exe, I get the following error: "can't connect to mysql server 'localhost' (10061)" What...
0
by: sowbug | last post by:
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem. However, when I try to connect(mysql -u root) from localhost, then I get access denied. Checked the user table and root can...
3
by: Pugi! | last post by:
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin): : #2002 Can't connect to local MySQL...
1
by: jiing | last post by:
Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0...
0
by: vicky | last post by:
Hello Experts, Trying to run sample Postgrel's ECPG(Embedded SQL)programs on RHL 9.0. Im unable to connect to PostgreSQL database (sirishadb) when I run the program .... # su postgres...
15
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...
5
by: scorpionbilli | last post by:
Hi, The local mysql server is running on my Macbook. I can access it through the console client: $ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.