Murray @ PlanetThoughtful wrote:
[EMAIL PROTECTED] wrote:
Hi Shawn,
Sorry, I'm talking about root the MySQL user account. The account
exists -- I can perform the following, for example:
c:mysql --user=root ptnew -p
Once I supply the password, this will put me in to the ptnew database
[EMAIL PROTECTED] wrote:
Murray @ PlanetThoughtful [EMAIL PROTECTED] wrote on 11/11/2005
08:44:37 PM:
Hi All,
I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine.
For some reason my root login can't access the mysql database anymore,
though I can use it to access
a better way of putting it) login anymore...
Does anyone know how I go about granting administrator privileges to
root for the mysql database?
Any help appreciated!
Much warmth,
Murray @ PlanetThoughtful
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
using more of a A C B type structure. I am trying to
stay away from using queries and inserts into the central database if
possible.
If anyone has dealth with this scenario before or know a good place to
look, please let me know.
Murray
--
MySQL General Mailing List
For list archives: http
Hi Guys,
How can I disable autocommit in the database. Can this only be done per session as
opposed to having it done globally at the database level.
Last where can I get a complete list and explanation of the buffer/memory areas of
mysql.
I checked the manual and it was brief at best.
Thanks,
Hi Guys,
I am running winxp with mysql 5.0.
I am attempting to run this statement
mysql load data infile c:\\mysql\\pop.txt into table population
(lastname,firstname,age,sickness);
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
and then a
If you resize the password column to what it was pre 4.1 it will store a
hash the same length as the old algo used to produce and users will be able
to log in just fine.
Michael Stassen pointed me to this link
http://www.mysql.com/doc/en/Password_hashing.html. and it has a number of
work
Hi guys,
I posted a similar question on this the other day but received no answers.
I'm running 5.0 and have a possible security/password problem. If i run from command
line all users work with or without passwords.
If I try and connect to mysql through php,perl,python or odbc with a user that
] ;
I can access mysql from command line and these -(php,perl,odbc,python
etc...)
- Original Message -
From: Gerald R. Jensen [EMAIL PROTECTED]
To: jamie murray [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 2:05 PM
Subject: Re: mysql 5.0
Jamie:
I
.
cheers!
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: jamie murray [EMAIL PROTECTED]
Cc: Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, January 04, 2004 3:05 PM
Subject: Re: mysql 5.0
Password security was improved in version
Hi Guys,
I am running winxp with mysql. Seeing this is a home machine there is no workstation
just one computer which I guess at this point is acting as my server and client for
mysql. I am just getting acquainted with mysql so I have been playing around with both
4.1 and 5.0. Neither database
can you show the actual code for php that does this.
- Original Message -
From: Reza Milan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 26, 2003 1:55 PM
Subject: SQL Support
Dear sirs,
I installed PHP and MYSQL on my XP system.
All commands supported except sql and
Plinio,
Hence my suggestion for use of a flat file. The file can be located on the
db server middle tier wherever it doesnt matter.
The important part is that you control what goes in the file and its done
ahead of time not when an enduser presses a button.
What about creating tables the users can
I'm new to MySql as well but the LOAD DATA statement is probably what
your looking for. It's a bulk loader and dumps the data from a flat file
into a designated table for you. You could easily automate this by writing a
simple perl script(probably php also but im not to familiar with that
What about creating a flat file on the middle tier from the database system
tables that the clients can view with your gui or web page.
Only things is keeping the file in sync with the system tables. But access
will be faster to the flat file and no security risks
because there won't even be a
Is this true? Has the license for the MySQL client libraries changed from
LGPL to GPL?
Murray Cumming
www.murrayc.com
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan Cox
Sent: Mittwoch, 10. Dezember 2003 10:22
To: [EMAIL PROTECTED
based on columns in the various tables. Can I do it using
a role-based model where I assign one or more of the above roles to a user
and grant the privileges to the role?
Murray Nicholas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
: Saturday, 12 July 2003 17:11
To: Murray; [EMAIL PROTECTED]
Subject: RE: Access control via a role based security model
Hi
You could achive what you want using grant statements, but you still need a
user interface to send queries to the database and display the information
sent back in a way
statement run against my local db?
Something conceptually like:
INSERT INTO `remotedb`.`tbldata` SELECT * FROM `localdb`.`tbldata` WHERE
recid=
Any help appreciated!
Much warmth,
Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...
* Worried
instead?
Much warmth,
Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
!
Much warmth,
Murray
http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, 7 June 2003 10:54 AM
To: Murray Wells; [EMAIL PROTECTED]
Subject: Re: Question / suggestion
=169.254.82.163
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-max.exe
user=[withheld]
password=[withheld]
Regards and best wishes,
Murray Wells
Hello All,
For some time I've been wondering if it's possible to write a program
that can automatically check my local MySQL server, create a recordset
containing any new or updated records found in my local table(s) since
the last check, and upload those new / updated records to the MySQL
server
All of the other distribution files on mysql.com are showing version
4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be
updated to 4.0.5 in the near future?
-
Before posting, please check:
Egor Egorov [EMAIL PROTECTED] writes:
1. replace Red Hat's rpms with MySQL binary release, download it from
http://www.mysql.com/
2. run myisamchk on all files.
3. run MySQL and enjoy the reliability since then :-)
Why do Linux distributions ship broken MySQL packages? The newly
released
Hi,
I need some help with a query
I have two queries that I'd like to merge into one - one returns a list of
matches that a player has played in, and the other returns the players
batting performance. My problem is that a player doesn't always bat, and
therefore can have fewer rows in the
?
cheers
Murray
--
The asp code looks like this:
Function Add()
Dim adoRec
Set adoRec = Server.CreateObject(ADODB.Recordset)
With adoRec
.Open Test, Connection, adOpenDynamic, adLockOptimistic, adCmdTable
.AddNew
.Fields(Name) = Added
.Update
Add = .Fields(TestID
be imported into.
Are their any API's to do this?
This is the mysqlcppapi list. mysqlcppapi is not MySQL++.
I don't know whether either of these APIs can be used to export table data to
files.
Murray Cumming
[EMAIL PROTECTED]
www.murrayc.com
and a DB server and using local IP's to connect
between the two. I'm kind of stuck here.
Anyone know what's causing the problem?
Thanks for your time.
Jim Murray
PaintballDojo.com
Hello,
I am running MySql 3.23.33 on Linux RH 6.2. In the documentation, it says if
you want to add a user that is allowed to connect from anywhere, use the "%"
symbol for host. When I add a user whil an empty host field or even a "%" -
I still get access denied... However when I go ahead and add
30 matches
Mail list logo