| View previous topic :: View next topic |
| Author |
Message |
an0nymity
n00b
Joined: 06 Jul 2002
Posts: 20
|
 Posted: Tue Dec 17, 2002 9:02 pm Post subject: MySQL login problems ..... |
 |
|
I have installed MySQL 3.23.54 about 3 times, and deleting the database to trouble shoot the same problem that I keep getting. If someone could help me, I'd greatly appreciate it.
Problem Synopsis:
emerge dev-db/mysql
** emerge successful **
/var/db/pkg/mysql-3.23.54/mysql3.23.54.ebuild config
** mysql databases being created **
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /etc/init.d/mysql start (you have to start the server first!) /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h krillan.an0nymity.com password 'new-password' See the manual for more instructions.
** passwords created **
mysqladmin create 'new-sql-database' (or and mysqladmin command)
Error I keep receiving:
| Code: | | error: 'Access denied for user: 'root@localhost' (Using password: NO)' |
Any one have a solution? at the present point, I unmerged mysql, killed all directories dealing with it, and re-emerged it, with no 'ebuild config' ... So I can get a fresh start on things. I'd appreciate any help in this matter.
Thanx,
An0nymity |
|
| Back to top |
|
 |
m0pr0be
Guru
Joined: 29 Aug 2002
Posts: 308
|
| Posted: Wed Dec 18, 2002 12:50 am Post subject: |
|
|
hi
have a look at your /etc/hosts.
the name localhost must be mapped to 127.0.0.1
otherwise mysql wont let you in. because root is only allowed acces from localhost.
....
oops just checking here at my machine
seems like i'm getting the same behaviour 
i'm trying to investigate. i will let you know if i found something |
|
| Back to top |
|
|
an0nymity
n00b
Joined: 06 Jul 2002
Posts: 20
|
| Posted: Wed Dec 18, 2002 1:31 am Post subject: |
|
|
thanx m0pr0be, I'll await your responce
For future refernces here is exactly what my " /etc/hosts " looks like.
| Code: | # /etc/hosts: This file describes a number of hostname-to-address
# mappings for the TCP/IP subsystem. It is mostly
# used at boot time, when no name servers are running.
# On small systems, this file can be used instead of a
# "named" name server. Just add the names, addresses
# and any aliases to this file...
# $Header: /home/cvsroot/gentoo-src/rc-scripts/etc/hosts,v 1.7 2002/11/18 19:39:22 azarah Exp $
#
127.0.0.1 localhost
xxx.x.x.x computer.mydomain.com computer |
|
|
| Back to top |
|
|
rac
Bodhisattva
Joined: 30 May 2002
Posts: 6553
Location: Japanifornia
|
| Posted: Wed Dec 18, 2002 2:59 am Post subject: |
|
|
Does adding the '-p' option and supplying a blank password work?
_________________
For every higher wall, there is a taller ladder |
|
| Back to top |
|
|
c_kuzmanic
Guru
Joined: 18 Apr 2002
Posts: 488
Location: Los Angeles , California
|
| Posted: Wed Dec 18, 2002 3:02 am Post subject: Re: MySQL login problems ..... |
|
|
| an0nymity wrote: |
mysqladmin create 'new-sql-database' (or and mysqladmin command)
|
Lol, it's really simple:
mysqladmin create 'new-sql-database' -p
You forgot the '-p' , thus not telling mysql to prompt you for a password.
Hope this helps:) |
|
| Back to top |
|
|
an0nymity
n00b
Joined: 06 Jul 2002
Posts: 20
|
| Posted: Wed Dec 18, 2002 3:39 am Post subject: |
|
|
ugh ... I feel so stupid, adding the "-p" arg to the mysqladmin syntax worked.
Someone have a dunce cap? |
|
| Back to top |
|
|
c_kuzmanic
Guru
Joined: 18 Apr 2002
Posts: 488
Location: Los Angeles , California
|
| Posted: Wed Dec 18, 2002 5:58 am Post subject: |
|
|
| an0nymity wrote: | ugh ... I feel so stupid, adding the "-p" arg to the mysqladmin syntax worked.
Someone have a dunce cap? |
Lol, don't be too hard on yourself about it, I remember spending half an hour of agony on that very same prob when I encountered it first:) |
|
| Back to top |
|
|
|
Other Things Gentoo
