Hi,
a while ago I had problems with users on mysql.
I am trying to login as root from the local host using password and I get
access denied using password=YES
the host column of my user table is set to % and I have done a flush
privileges
and from other certain hosts I cannot login as root
Hi,
I have a blank table for some testing.
1 of the fields (the primary key) is an auto_increment and not null.
how and what do I insert into this field to start off the recordsets. also
once I have set the records going say to 1, what do I then insert if
anything into this field for the next
thanks a simple but effective explination.
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2002 22:29
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Can Anyone explain / help with auto_increment fields.
At 10:23 PM 1/23/2002 +, you
I am an experienced programmed and have worked on Unix and with Oracle and
Informix for many years.
I personally am struggling to get my head around Mysql (getting there now
though) I think part of the reason I am posting simple questions is.
1.) I find the manual quite combersome for
.
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:04 AM
To: Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it
I read similar notes on this in the manual, saying that invoking mysql
without the username
to care as it almost seems to ignore the Host
column.
GRANT ALL PRIVILEGES ON *.* TO foo@localhost IDENTIFIED BY 'password' WITH
GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'password' WITH GRANT
OPTION;
Good luck.
Doug
On Wed, 9 Jan 2002 20:38:46 -, Matthew Darcy wrote
Can anyone give me an example of an alter table syntax that.
1.) adds a column
2.) deletes a column.
I am reading the examples in the oreilly book, and it does not work
also the Oracle or Infomix syntax doesn't work.
can someone give me a clue please.
Thanks,
Matt.
Hi,
in Oracle I have a test database. there are 2 tables table1 and table2.
there is a field on both tables called account_number. on table 1 it is set
to auto increment.
I have set up a trigger so that when a number is generated in table1 it
copies the number to account_number on table 2.
not allow you to connect using user
user.
Kam
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 7:31 AM
To: Carl Troein; [EMAIL PROTECTED]
Subject: RE: command mysql -u $user without typing it
Carl,
great attempt, but that would be far
[mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 15:30
To: [EMAIL PROTECTED]
Cc: MySql List
Subject: Re: triggers and references.
The many simple questions you ask imply that you have not read the manual.
Triggers are not supported.
Matthew Darcy wrote:
Hi,
in Oracle I have a test database
for a password, just
pressing return lets me in.
Can you post the results of:
select user, name, host from user;
It may help.
Quentin
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 11:10 p.m.
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE
I have clustered Netra's together before using SUN HA and Vertias VCS.
I found for large content avoid the Netra X1 - more so for webstuff, they
run on a very slow IDE bus. They work excellently for say processing like
the middleware box, or actual webservers but disk heavy apps I would avoid
as
Hi,
I have connect to the mysql database as root, and added a user called test
one with the host field containing a % and all the other options with a Y.
In theory I should be able to connect to a remote database as test1 form any
host ? is this correct ?
I am have tried using mysqlgui and
in the db table there is the db field.
if I put in db1 in this field then the user test1 will only be able to
connect to db1.
the questions I have (I can't quite figure it out from the manual)
1.) how can I get it so test1 can connect to db1 and db2 but not db3. Do I
have to put in 2 entries
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
but I would like test1 2 and 3 to be able to type mysql and be either
: command mysql -u $user without typing it
Matthew Darcy wrote:
I have 3 UNIX users on my server.
test1, test2, and test3.
I have created 3 users for mysql test1, test2, and test3 (shock horror)
If I want to connect to the database as root then I understand I must do
mysql -u root -p
: command mysql -u $user without typing it
Try this:
mysql grant all privileges on *.* to test2@localhost
also read manual about the grant command.
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:04 AM
To: Gerald Clark
Cc: MySql List
typing it
The Query OK, 0 rows affected indicate that the user table is updated so
test2 on localhost can access the mysql databases.
Do you still get the access is denyed for user @localhostto database mysql
message?
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED
.
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2002 19:43
To: Matthew Darcy
Cc: Ho Kam; Gerald Clark; MySql List
Subject: RE: command mysql -u $user without typing it
You must do a FLUSH PRIVILEGES after making any changes to the user
permissions before
:[EMAIL PROTECTED]]
Sent: 09 January 2002 21:33
To: Matthew Darcy
Cc: Ho Kam; Gerald Clark; MySql List
Subject: RE: command mysql -u $user without typing it
The mysql user permissions are just a table in the mysql database. Whenever
you do a GRANT, you're really just doing an INSERT or UPDATE
I was reading about adding/managing users.
I understand hat the user table holds user information.
the example I will give is taken from the oreilly book.
insert into user (host, user, password, select_priv, insert_priv,
update_priv, delete_priv)
values ('%', 'bob', password('mypass'), 'Y',
% is a wild card. Yes bob can use any host at user table is global.
Yes you can use clear text passwords.
Hope this helps.
Simon
PS I like using desc tablename
PPS Get the new O'reilly book the old one is not so good!
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 08
I just installed mysql under my new linux system.
I did a test command of
./mysqladmin -u root password new-password
thus setting the root users password to new-password
this appeared to work.
I now want to change the root users password now that I have the syntax
correct.
I do a
Hi,
my laptop is running windows 2000 and is called jaguar.
I have mysql running on a linux server called jordan.
when I fire up mysqlui and tell it to connec to jordan as root I get
prompted for a password. I enter the password (that I have tested and is
correct) and it say at the bottom of
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
have looked at these commands and cannot see how I can create mysql users.
Am I missing something that is staring me in the face ?
Thanks,
Matt.
(slowing getting the hang of what is going on now)
I am having the same problem.
My laptop jaguar is not allowed to connect to my server (jordan)
I get jaguar is not allowed. I think it is something to do with granting
user root from jaguar to root@jordan ??? I am trying to figure out what is
going on ?
If you read back I posted a couple
I never sent a mail to unsubscribe ???
have I been booted from the list or what ??
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please send an empty reply
to this
, Matthew Darcy wrote:
I am having the same problem.
My laptop jaguar is not allowed to connect to my server (jordan)
I get jaguar is not allowed. I think it is something to do with granting
user root from jaguar to root@jordan ??? I am trying to figure out what is
going on ?
If you read back I
try restarting port mapper on the linux box.
also make sure swap is not almost used as sockets uses tmp to swap out tcp
requests.
-Original Message-
From: Michael J. Cermak, Jr. [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 19:36
To: [EMAIL PROTECTED]
Subject: Newbie needs serious
Hi,
I have a redhat server, running apache 1.3.20. The server is running a
couple of virtual servers for different websites. I now wish to add a few
new virtual servers/domains to the machine. However (here is the twist)
these sites will need to use a different mysql schema each and have some
are interested drop me a personal mail.
-Original Message-
From: j.urban [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 15:44
To: Matthew Darcy
Cc: [EMAIL PROTECTED]
Subject: Re: Using MYSQL and PHP With Vitual Apache Servers ?
Why not just create separate databases for each virtual server
I have a server called jordan, that is running mysql under linux.
I have a laptop called jaguar which I am trying to launch the mysql gui on
to connet to jordan.
I have configured jaguar to connect to jordan, when I click connect it asks
me for a password - I have not set the password yet so
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 27 December 2001 14:08
To: Count Schemula
Subject: RE: Re: host not allowed to connect ? more problems
Hi,
I have re-read and think I understand a little better (think being the
correct word)
I have decided
Hi,
a week or so ago I requested some info on mysql gui's. I got some great info
and feedback. The PHP admin tool seems to be one of the most popular. As I
was cleaning out my mailbox I deleted a lot of mails I shouldn't have. Can I
have some good links for some linux gui's (pref tools or
Is this the output you would expect from a correctly compiled and installed
mysql system when running mysql_install_db
Also where is the support-files this message speaks of,
Thanks,
Matt.
[mysqldba@jordan bin]$ ./mysql_install_db
Installing all prepared tables
011220 15:38:01
I have set the root password for the mysql install.
I have read the manual and want to make a new database. I ran
mysql_install_db (see my other mail today) which seemed to do little, then
did what the manual told me with
[mysqldba@jordan bin]$ ./mysqladmin create bathjobs
./mysqladmin: CREATE
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: RE: As plain as the nose on your face
try
./mysqladmin -u root -p create bathjobs
and FYI,
./mysqladmin --help
Thank you.
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2001 03:38 PM
To: [EMAIL PROTECTED
use rpm -Uvh --force $PACKAGE
-Original Message-
From: Jeremiah Jester [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 22:35
To: 'MySQL'
Subject: Reset MySQL Root password
Well it seems as though i may have mistyped my root password for mysql since
nothing seems be working. Anybody
or rpm -e $PACKAGE then re-install.
-Original Message-
From: Jeremiah Jester [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 22:35
To: 'MySQL'
Subject: Reset MySQL Root password
Well it seems as though i may have mistyped my root password for mysql since
nothing seems be working.
On Wednesday 19 December 2001 12:27 pm, Matthew Darcy wrote:
Hi,
I am having this exact error message. I have not used mysql before and I
mailed this question before and someone answered but it didn't work. I have
compiled and installed mysql. I run the mysql_install_db script and it
tells
Hi,
I am having this exact error message. I have not used mysql before and I
mailed this question before and someone answered but it didn't work. I have
compiled and installed mysql. I run the mysql_install_db script and it tells
me to change my password. I have never set a password as this
Ok the password problem is sorted
just to make sure i am right the command I used was
./mysqladmin -u root password $password
I have just ran mysql_install_db which didn't seem to do much except remind
me to change me password.
I have done a mysqladmin create test1
I then get the error that
Hi,
I am not normally a fan of gui's but seeing as I am finding mysql a bit
different from oracle I could use all the help I can get as my database may
end up quite complicated.
Are the gui's available for linux ??? are they any good.
Thanks,
Matt.
I have compiled and installed mysql on redhat 7.1
I am having a few problems.
1.) I compiled and installed as root then changed the ownership to the dba
account.
Will this cause any problems down the line.
2.) Is there s startup and shutdown script to put in /etc/rc.d/init.d or do
I have to
Hi,
I have compiled and installed as root mysql succesfully. I gave ownership of
the install to my dba account and group. when I do a mysql connect local as
the dba account I get a permission denied. Why is this and where are the
actual tables and data held.
Thanks,
Matt.
Hi,
I was wondering if the mysql list had any plans to be put onto a news group.
I
have only been a memeber a short time but I have found %50 of the
information to be usefull. This does however mean that %50 is does not apply
to me at this time.
Due to this I get a lot of emails that are of
I compiled without problem mysql on Redhat linux 7.1
I have just started the sever using nohup /usr/local/mysql/libexec/mysqld
This started fine without problem.
as I am used to using Oracle and new to mysql I decided to do an
mysql_install_db which prompted me saying
remember to change
I have done oracle on NFS and it is not really the best option due to NFS
locking.
ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you
are using automount maps) dies this will hold your development/production up
no end. Also oracle's table locking (not sure if mysql has
I compiled without problem mysql on Redhat linux 7.1
I have just started the sever using nohup /usr/local/mysql/libexec/mysqld
This started fine without problem.
as I am used to using Oracle and new to mysql I decided to do an
mysql_install_db which prompted me saying
remember to change
.
-Original Message-
From: Alan W. Rateliff, II [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2001 15:15
To: Matthew Darcy
Subject: Re: Problems compiling under Solaris 2.6
On 05-Dec-01, Matthew Darcy said something totally profound about Problems
compiling under Solaris 2.6 that made me ponder
50 matches
Mail list logo