MySQL and Linux - dababase connection problem

[Jim Sabatke]

When I installed MySQL (SuSE 9.0) and first started it, it
told me that I needed to set a password for
machine.domain.name. I tried following the directions, but
it would only setup a password for "localhost".

Is this normal?

I am having problems with software connecting to the database.
--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Andreas Paasch]

Attempting to reach the Kolinahr, Jim Sabatke wrote:

When I installed MySQL (SuSE 9.0) and first started it, it told me that I
needed to set a password for machine.domain.name. I tried following the
directions, but it would only setup a password for "localhost".

Is this normal?

I am having problems with software connecting to the database.

In case of trouble, read the book of instructions.

www.mysql.com

/Andreas
--
#Peace and long life ...
Registeret Linux user #292411

[Andreas Paasch]

Attempting to reach the Kolinahr, Jim Sabatke wrote:

When I installed MySQL (SuSE 9.0) and first started it, it told me that I
needed to set a password for machine.domain.name. I tried following the
directions, but it would only setup a password for "localhost".

Is this normal?

I am having problems with software connecting to the database.

In case of trouble, read the book of instructions.

www.mysql.com

/Andreas
--
#Peace and long life ...
Registeret Linux user #292411

[Jim Sabatke]

Andreas Paasch wrote:

Attempting to reach the Kolinahr, Jim Sabatke wrote:

When I installed MySQL (SuSE 9.0) and first started it, it told me that I
needed to set a password for machine.domain.name. I tried following the
directions, but it would only setup a password for "localhost".

Is this normal?

I am having problems with software connecting to the database.

In case of trouble, read the book of instructions.

www.mysql.com

/Andreas

I've been doing that, over and over.

--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Jim Sabatke]

Andreas Paasch wrote:

Attempting to reach the Kolinahr, Jim Sabatke wrote:

When I installed MySQL (SuSE 9.0) and first started it, it told me that I
needed to set a password for machine.domain.name. I tried following the
directions, but it would only setup a password for "localhost".

Is this normal?

I am having problems with software connecting to the database.

In case of trouble, read the book of instructions.

www.mysql.com

/Andreas

I've been doing that, over and over.

--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Aggro]

Jim Sabatke wrote:

I am having problems with software connecting to the database.

Information about what you did, and what was the error message would
help people to answer.

[Aggro]

Jim Sabatke wrote:

I am having problems with software connecting to the database.

Information about what you did, and what was the error message would
help people to answer.

[Jim Sabatke]

Aggro wrote:

Jim Sabatke wrote:

I am having problems with software connecting to the database.

Information about what you did, and what was the error message would
help people to answer.

I know it would be, but I don't have much. Here's what I did:

1. Installed MySQL and had it working.
2. Had some database problems I couldn't resolve. This
involved Posfix and Cyrus.
3. Finally gave up and uninstalled MySQL
4. Deleted the MySQL database files.
5. Reinstalled MySQL
6. Started MySQL
- Got a normal message to set the root user, and the
root yoda (my host name).
- root password set fine.
- root yoda password would not set. Got an error that
the database could not be accessed by the host.
- only "localhost" is valid for access

Is this normal? I'm having application problems of various
kinds, and the errors are application specific.

I'm not expecting Postfix/Cyrus support here. I know lots
of people have had problems getting them working with MySQL
though.

--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Jim Sabatke]

Aggro wrote:

Jim Sabatke wrote:

I am having problems with software connecting to the database.

Information about what you did, and what was the error message would
help people to answer.

I know it would be, but I don't have much. Here's what I did:

1. Installed MySQL and had it working.
2. Had some database problems I couldn't resolve. This
involved Posfix and Cyrus.
3. Finally gave up and uninstalled MySQL
4. Deleted the MySQL database files.
5. Reinstalled MySQL
6. Started MySQL
- Got a normal message to set the root user, and the
root yoda (my host name).
- root password set fine.
- root yoda password would not set. Got an error that
the database could not be accessed by the host.
- only "localhost" is valid for access

Is this normal? I'm having application problems of various
kinds, and the errors are application specific.

I'm not expecting Postfix/Cyrus support here. I know lots
of people have had problems getting them working with MySQL
though.

--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Aggro]

Jim Sabatke wrote:

- root yoda password would not set. Got an error that the database
could not be accessed by the host.
- only "localhost" is valid for access

How did you set local and remote passwords? Did you use commandline
tools(if so, what were the commands you used) or some GUI tools?

[Aggro]

Jim Sabatke wrote:

- root yoda password would not set. Got an error that the database
could not be accessed by the host.
- only "localhost" is valid for access

How did you set local and remote passwords? Did you use commandline
tools(if so, what were the commands you used) or some GUI tools?

[Jim Sabatke]

Aggro wrote:

Jim Sabatke wrote:

- root yoda password would not set. Got an error that the database
could not be accessed by the host.
- only "localhost" is valid for access

How did you set local and remote passwords? Did you use commandline
tools(if so, what were the commands you used) or some GUI tools?

I used the command line utilities specified by the message
on first starting mysql. It was a text message that was
lost. I feel like an idiot for not copying and pasting it
somewhere, but I wasn't expecting problems.

--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Jim Sabatke]

Aggro wrote:

Jim Sabatke wrote:

- root yoda password would not set. Got an error that the database
could not be accessed by the host.
- only "localhost" is valid for access

How did you set local and remote passwords? Did you use commandline
tools(if so, what were the commands you used) or some GUI tools?

I used the command line utilities specified by the message
on first starting mysql. It was a text message that was
lost. I feel like an idiot for not copying and pasting it
somewhere, but I wasn't expecting problems.

--
Jim Sabatke
Hire Me!! - See my resume at http://my.execpc.com/~jsabatke

Do not meddle in the affairs of Dragons, for you are crunchy
and good with ketchup.

[Aggro]

Jim Sabatke wrote:

I used the command line utilities specified by the message on first
starting mysql. It was a text message that was lost. I feel like an
idiot for not copying and pasting it somewhere, but I wasn't expecting
problems.

Ok, so better start from beginning. Since you have a working root
password, I assume you know how to log in into mysql as root. If not,
then just try typing:
mysql -u root -p
[ Type in the password ]

Next, here is something for you to read:

http://dev.mysql.com/doc/mysql/en/GRANT.html

And try giving some commands like:
GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost' IDENTIFIED BY
'password here';

Where you replace the test with the database name you wish to connect
to, and localhost with the ip (or name) of the computer _from where_ you
wish to connect to this server. I also suggest you not to allow remote
root access at all, if that is possible (for security reasons), instead
create another user for your needs.

I don't know how you are planning to use the database, so this is about
all I can tell.

[Aggro]

Jim Sabatke wrote:

I used the command line utilities specified by the message on first
starting mysql. It was a text message that was lost. I feel like an
idiot for not copying and pasting it somewhere, but I wasn't expecting
problems.

Ok, so better start from beginning. Since you have a working root
password, I assume you know how to log in into mysql as root. If not,
then just try typing:
mysql -u root -p
[ Type in the password ]

Next, here is something for you to read:

http://dev.mysql.com/doc/mysql/en/GRANT.html

And try giving some commands like:
GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost' IDENTIFIED BY
'password here';

Where you replace the test with the database name you wish to connect
to, and localhost with the ip (or name) of the computer _from where_ you
wish to connect to this server. I also suggest you not to allow remote
root access at all, if that is possible (for security reasons), instead
create another user for your needs.

I don't know how you are planning to use the database, so this is about
all I can tell.