By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,864 Members | 1,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,864 IT Pros & Developers. It's quick & easy.

MySQL and Linux - dababase connection problem

P: n/a
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.
Jul 20 '05 #1
Share this Question
Share on Google+
14 Replies


P: n/a
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
Jul 20 '05 #2

P: n/a
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
Jul 20 '05 #3

P: n/a
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.
Jul 20 '05 #4

P: n/a
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.
Jul 20 '05 #5

P: n/a
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.
Jul 20 '05 #6

P: n/a
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.
Jul 20 '05 #7

P: n/a
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.
Jul 20 '05 #8

P: n/a
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.
Jul 20 '05 #9

P: n/a
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?
Jul 20 '05 #10

P: n/a
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?
Jul 20 '05 #11

P: n/a
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.
Jul 20 '05 #12

P: n/a
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.
Jul 20 '05 #13

P: n/a
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.
Jul 20 '05 #14

P: n/a
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.
Jul 20 '05 #15

This discussion thread is closed

Replies have been disabled for this discussion.