I have a table with several columns of type 'varchar'. How can I change all
columns to fixed width char's ? Doing a 'alter' from varchar to char has no
effect since the column is changed back to varchar.
-
Before posting, plea
>I suspect that you need to add an entry at the MySQL host for the machine
that you are connecting from. This can be done with a GRANT statement:
>
>- Format:
>grant all privileges on databaseName.tableName
>to 'userName'@'hostName'
>identified by 'somePassword';
>
>
>- Example
Yes it is perfectly possible. I did that some months ago and it worked perfectly. I,
however, had to install MyODBC on the windows box. There is a good tutorial I used at
http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html
Its a good tutorial By W.J. Gilmore.
Please take note of the deci
[EMAIL PROTECTED] writes:
> More so will i need to open MySQL server on my local machine before running
> MySQL client to connect to the remote machine e.g.
A client is a client and a server is a server. The point of separating
the two is that you can then run the client somewhere and and the
s
When I try to do anything with MySQL, I always see
"Ignoring query to other database" on my screen. When I type "status", the
computer prints:
"All updates ignored to this database".
after "Current user".
Could anybody help me ? Does anybody know how can I unblock MySQL ?
robertix
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 no
Hi,
Where one can alter the number of connections going to MySQL?
Jari Mäkelä
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
Hi Matt,
I am sure this has been said before so my apologies if I bore!
Most mail clients let you setup rules. For the mySQL list I automatically
redirect all messages into a separate folder based on the [EMAIL PROTECTED]
email address. This creates a fabulous resource that can be searched (ti
Compliments,
I was able to uccessful install MySQLGUI version 1.75 on my win 98 running
MySQL server 3.23.43 -max-debug client version 3.23.3 alpha.
I was also able to connect to the server. At the bottom of the window I saw
one button with plus sign, when I do mouse over on it there is this pop
Hi,
I'd like to be able to reserve some connections to the MySQL
server for emergencies - eg. someone issued a slow query and locked out
several hundred updates from several hundred other connections.
Currently in this sort of situation, it is possible to completely
run out of connections and
The MySQL documentation says:
"To ensure that the update log/binary log can be used to re-create the
original tables, MySQL will not allow concurrent inserts during INSERT
SELECT"
Does this mean:
A.
An INSERT...SELECT cannot run if any other SELECT is running on the table
OR
B.
An INSERT
Tony Buckley writes:
> I am not a great fan of Newsgroups - they get spammed too much and messages
> get lost or archived. Some ISPs carry them, some don't. All too hit and
> miss for a resource on which I rely and am very grateful for.
I agree, but sadly enough the spam part is true for this
Philip Molter writes:
> On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote:
> : Dave Burgess had a good suggestion; I suppose you could specify the default in
>hex...
> : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1.
>
> I compiled a 3.23.46 last night an
Mike Wexler writes:
>
>
> Quentin Bennett wrote:
>
>
> >
> > Shell escape
> >
> > mysql> !rm /tmp/data.txt
> > mysql> select col into outfile '/tmp/data.txt' from table;
> >
> >
> >
> > mysql> select col into local outfile '/tmp/data.txt' from table
> >
> >
> >
> > Would these options pr
Philip Molter writes:
> >Description:
>
> When I do this:
>
> mysql>create table test_default ( testint int not null default 1 );
> mysql>desc test_default;
>
> I get:
>
> +-+-+--+-+--+---+
> | Field | Type| Null | Key | Default | Extra |
>
also screen what you don't need.
I delete everything regarding installation. I don't have solaris and I
don't have red hat so 80% of the install questions I can't help.
You can set up pretty complex sorting rules. It might take a couple of
weeks to set up, but once it's done you should receive on
Hi,
I've got this problem:
I have two tables and I want create third one with LEFT JOIN
First table table1 containts field AA as a primary key (AA is NOT NULL).
Second table table2 containts field AA as a primary key (AA is NOT NULL)
too.
Ex:
CREATE TABLE a (PRIMARY KEY(AA))
SELECT table1.AA F
How come this passed the spam filter?
Which word it had that was on the "mandatory words" list ?
There is no sql, query, database in the text...
Etienne
Bege John wrote:
>
> I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the
>letter and you will not worry whe
Etienne Marcotte writes:
> How come this passed the spam filter?
>
> Which word it had that was on the "mandatory words" list ?
EEek! Noo... but that can't be.. or...?
Is the whole thing about the MySQL database just a hoax to get people
to subscribe to this list so that the people at MySQ
Hi folks,
does embedded server tcp-listen to the outside world i.e. it could
be used by another app or perhaps been accessed by the same app
using ODBC?
OR
is MySQL C API the only way to control it?
Thanks, Marek
-
Before po
I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums
for talk like this, web-based, and runs off of the MySQL server as a
back-end. An example in action is vbulletin itself or
community.installshield.com. Very slick indeed.
Kelly
FYI, I'm somewhat biased in favor of it
Compliments,
I was able to uccessful install MySQLGUI version 1.75 on my win 98 running
MySQL server 3.23.43 -max-debug client version 3.23.3 alpha.
I was also able to connect to the server. At the bottom of the window I saw
one button with plus sign, when I do mouse over on it there is this p
[EMAIL PROTECTED] writes:
> Compliments,
>
> I was able to uccessful install MySQLGUI version 1.75 on my win 98 running
> MySQL server 3.23.43 -max-debug client version 3.23.3 alpha.
>
> I was also able to connect to the server. At the bottom of the window I saw
> one button with plus sign, when
Marek Kustka writes:
> Hi folks,
>
> does embedded server tcp-listen to the outside world i.e. it could
> be used by another app or perhaps been accessed by the same app
> using ODBC?
>
Nope.
> OR
>
> is MySQL C API the only way to control it?
>
Yes, so far. But other API's could be built o
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 pass
My questions concern a setup where a public server is running at our
hosting company and a local office server is behind a firewall
(connected to the net via a somewhat unreliable ADSL).
The servers are configured in a circular master-slave relationship but
only a limited number of tables in the
On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote:
: Philip Molter writes:
: > >Description:
: >
: > When I do this:
: >
: > mysql>create table test_default ( testint int not null default 1 );
: > mysql>desc test_default;
: >
: > I get:
: >
: > +-+-+-
mysql> create table gd_records(
-> id int unsigned auto_increment,
-> res_skills
set("skills1","skills2","skills3","skills4","skills5","skills6"),
-> res_skills_ma
set("skills_ma1","skills_ma2","skills_ma3","skills_ma4","skills_ma5","skills_ma6"),
-> primary key(id));
Query OK, 0 r
Well that's called a forum
and it's not at all like a mailing list :-)
But yes there could be a forum, but there are already some on the net
www.devshed.com have a mySQL part and a Perl part and a PHP part. Plus a
forum requires servers, space, web hosting, DNS, maintenance,
moderation, programmi
Hi,
I'm new to both MySQL and LINUX, however still managed to kind of get them
up and running.
I installed MySQL whilst I was logged in as ROOT. Now I can only run it when
I log is as ROOT. How do change permissions of the other users so they can
also run MySQL or create a new user which will
I believe that phpmyAdmin uses the "show databases" syntax to see what is
available. To prevent it from seeing any db which the user is not
authorized, set the
safe_show_database = 1
in the my.ini file (or my.cnf). This will prevent show databases from
returning a list of all dbs available.
ke
Good morning Kamal,
From: <[EMAIL PROTECTED]>
> More so will i need to open MySQL server on my local machine before running
> MySQL client to connect to the remote machine e.g.
No. The service (mysqld) is strictly assigned to managing the local database(s) and to
serve access to those databas
Actually I setup a vBulletin forum for MySQL over at www.mysqlforums.com
and I am the moderator of the MySQL and Server Configuration forums over
at www.vbulletin.com/forum/
I've been keeping an archive of the mailing lists, mainly for my own
purposes to search through old questions and answers f
On Wed, 2001-12-12 at 06:49, Carl Troein wrote:
> Tony Buckley writes:
>> I am not a great fan of Newsgroups - they get spammed too much and messages
>> get lost or archived. Some ISPs carry them, some don't. All too hit and
>> miss for a resource on which I rely and am very grateful for.
> I
We just upgraded a box (RH 7.2) to current Apache, PHP, and MySQL. We used
the MySQL binary for 3.23.46. On the old box which was nearly identical we
were running 3.23.43 (I think). The old box didn't have any problems w/
MySQL but this box is having problems. The only real thing that changed wa
The problem is that you all are close-minded. Here, somebody as taken the
time to offer you an opportunity to make millions from the internet, and you
insult him.
INGRATES...all of you...INGRATES
I, for plan to avail myself of this fine opportunity. In a year, I'll be
basking on the beaches o
On Wed, 12 Dec 2001, Jari =?iso-8859-1?Q?M=E4kel=E4?= wrote:
> Date: Wed, 12 Dec 2001 13:25:09 +0200
> From: Jari =?iso-8859-1?Q?M=E4kel=E4?= <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: changing allowed number of connections
>
> Hi,
>
> Where one can alter the number of connections g
Hi All,
In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What
might be the
problem. please let me know.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
I am quite new with MySQL and I have a question. How can I easily make a
copy of a mysql database locally stored on a server where I have all admin
rights etc. I did not find such a utility/command in the standard MySQL
manual nor in admin utilities I use.
I use currently the mysqldump utili
Hi! Dose anyone has a experience to building mysql database in network files
system? and php? can you get me some information? thank you
-Original Message-
From: Marek Kustka [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 8:23 AM
To: [EMAIL PROTECTED]
Subject: Embedded MyS
Check out the GRANTS section in the MYSQL manual
-Original Message-
From: Faizal Mangera [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 9:38 AM
To: [EMAIL PROTECTED]
Subject: user permissions in linux
Hi,
I'm new to both MySQL and LINUX, however still managed to kind of
Which group(s) would this go under in the my.cnf ??
>On Wed, 12 Dec 2001 07:27:54 -0600, "Kelly Firkins" <[EMAIL PROTECTED]>
>wrote:
>>I believe that phpmyAdmin uses the "show databases" syntax to see what is
>>available. To prevent it from seeing any db which the user is not
>>authorized
even/odd is a little limiting, what happens down the road when another
site needs to be added.
A better method might be to use a unique session ID for each client site
in combination with a
generated sequence ID see the white paper
at:http://www.ambysoft.com/persistenceLayer.html
in particular
At 7:12 PM +0530 12/12/01, sreedhar wrote:
>Hi All,
>
>In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What
>might be the
>problem. please let me know.
>
>regards,
>sreedhar
That's not enough information.
Let's see the CREATE TABLE statement, a sample INSERT statement, and
t
No, it's not accepting NULL if it was declared as NOT NULL.
It's just accepting an empty sting ( "" ).
CREATE TABLE test (t VARCHAR(10) NOT NULL);
INSERT INTO test SET t = NULL;
INSERT INTO test SET t = '';
First insert will tell you what you're waiting for. And the second one
will do what you
At 9:32 AM +0100 12/12/01, Willem Bison wrote:
>I have a table with several columns of type 'varchar'. How can I change all
>columns to fixed width char's ? Doing a 'alter' from varchar to char has no
>effect since the column is changed back to varchar.
You have to change them all at ones in the
Which group(s) would the following options be put under to enable in the my.cnf.
safe_show_database
skip_show_database
Thx's
mysql sql database
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thu
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 th
How about going to the dir where the mysql database is then just cp *
/backupsqldatabase
And just the other way when you want to restore then use fix database.
Thats what I have done and it seems to work fine.
> Hi,
>
> I am quite new with MySQL and I have a question. How can I easily make a
> c
Hi,
When I try to do a "bk pull", I have the following unexpected message :
>bk pull
bk://work.mysql.com:7001: No route to host
What's wrong ?
Best Regards,
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
ht
Hello, im wondering if anybody can tell me how can i tune up my sql so that
can run smoothly... if there is any packet i should install...
i have a debian linux in a pentium 3 800 mhz with 256.
thanks
Hernan
-
Before posting,
Greetings-
I have a MySQL database with a table (job_table) containing information
concerning jobs I run. Among the fields on the table are job_id
(varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry
to the table with the job_id, timestamp, and associated information, so the
On Tue, Dec 11, 2001 at 07:34:11PM -0800, Kendra L Knudtzon wrote:
> I am having problems with this nested inner join statement:
>
> SELECT tblMethodType.MethodType, tblMethodParm.MethodName,
> tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip
> FROM tblMethodType INNER JO
At 17:40 11/12/01, you wrote:
>Can you provide your table description?
>
>You have two set colums? One called res_skills and one called
>res_skills_ma ?
Yeah, Both are SET columns.
Wil
-
Before posting, please check:
http:/
Hello
I've got a problem selecting values that match an option from a SET column.
My two columns are set up as follows:
res_places SET('North','West','South')
res_places_re SET('Aber','Cardiff','Bangor')
And I'm currently using the following MySQL query:
SELE
For mysql, if your datafiles will not fit in ram, I would highly
recommend not putting it on nfs. Mysql doesn't have any data caching,
so every query will have to go thru the network to get the data. if,
however, you do have enough ram on the machine to store all the
datafiles in memory, the
can't you select the latest timestamp?
On Wed, 12 Dec 2001, Lindstrom Greg - glinds wrote:
> Greetings-
>
> I have a MySQL database with a table (job_table) containing information
> concerning jobs I run. Among the fields on the table are job_id
> (varchar(10)), and timestamp (a timestamp). As
> -Original Message-
> From: Scroggin, Steve
> Sent: Tuesday, December 11, 2001 8:47 AM
> To: '[EMAIL PROTECTED]'
> Cc: Firemon Support
> Subject: Embedded Server Binary
>
> MySQL Representative:
>
> Your website states that downloading the binary is better than com
Maybe some coding/mysql master out there knows an answer to this tricky
problem...
We've recently migrated all our mysql servers from 3.23.42 to 3.23.45 without
any problems except for one server.
That linux server shows after startup of mysql after 1 or 2 minutes an
exceptionally high load an
Hi all,
2 littles questions.
1. How can i log all connection attempt to the mysql database without logging all the
query in the mysql database ?
2. It is possible to prevent user to the 'show database' command, i know they can't
use it depending on the right granted but it will be pleasent to
HI
I installed MyODBC on an NT server to connect via the internet to my
Linux box that runs mysql3.23. I have already populated tables in a db
that I am trying to link to the NT server via ODBC, but I am getting
errors when trying to do this.
The table is created with an id field ( BIGINT (255)
Hi,
The TurboPower new groups (news://news.turbopower.com) seem to work fine,
with little spam. Because they host the news groups themselves, there is no
problem with them not being hosted by a particular ISP.
It would be really nice to have a new group, but the ground has been covered
so many t
Are there plans for mysql to have the capabilities to execute single sql
statement with nested SELECT . or Is there a way around this for the time
being?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual
Hello there,
Wondering if anyone could help with a problem. I'm upgrading a customer's
server from a text based version of our program, to a MySQL based. There
are 2 databases, DB1 and DB2, which contain 5 and 4 tables respectively.
The upgrade script I am running simply adds information to 3
Hi,
I have a similar load problem when I start MySQL-4.0 and there is high
number of apache process requesting MySQL connection.
I had to shutdown and restart apache otherwise the load often goes up to 200
and more (!!). (there are more than 250 visitors always connected to the
server, so it gene
Hi
I'd like to compile the new PHP 4.1.0, but
it always stops at the libmysqlclient.a with these
error messages:
/usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file':
dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file'
/usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(
Hello all,
I'm moving from ASP to PHP & MSSQL to Mysql, but I have some
doubt.
It is possible in MySQL Bi-Directional Replications? If it's,
then I need to find some documentation about it. Where can I find it?
TIA
Pedro
--
Greg,
> I have a MySQL database with a table (job_table) containing information
> concerning jobs I run. Among the fields on the table are job_id
> (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry
> to the table with the job_id, timestamp, and associated information, so
Hi
How can I set up our mysql server to
write its logs into a log file?
Thanks in advance!
Regards
Istvan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> When I try to do a "bk pull", I have the following unexpected message :
>
> >bk pull
> bk://work.mysql.com:7001: No route to host
>
> What's wrong ?
Hi,
It should be fixed now. We were doing an internet connection upgrade
(from 10mb to 100mb).
Hi,
I've got a feature request which I don't think should be all that hard
to implement (if not already)
With in the mysql fulltext search system if your search words exist in
more than 50% of the records; it is ignored.
How about having mysql return either an error or set something that can
b
Hi.
MySQL already reserves one connection to users with the process
privilege. So assure that common clients don't have the process
privilege and you connect with one that has it and you are done.
This is documented here (found no other place):
http://www.mysql.com/doc/T/o/Too_many_connections.h
Hi,
Take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
- Original Message -
From: "Alexander Skwar" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 12,
Hello,
There's a problem with mysql query, which I would like to report to
all of you. I'm not sure if it can be taken as a "bug" though.
Suppose we have a very simple table with only three or four fields.
Let's say the table is "employee", and one of the fields is "name" in
varchar or char ty
HI
I installed MyODBC on an NT server to connect via the internet to my
Linux box that runs mysql3.23. I have already populated tables in a db
that I am trying to link to the NT server via ODBC, but I am getting
errors when trying to do this.
The table is created with an id field ( BIGINT (255)
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 pas
Hi!
On Dec 12, Colin Faber wrote:
> Hi,
>
> I've got a feature request which I don't think should be all that hard
> to implement (if not already)
>
> With in the mysql fulltext search system if your search words exist in
> more than 50% of the records; it is ignored.
>
> How about having mys
The new programmer for our company is not using the dataType "password" or
any encryption what so ever for our user accounts (accounts that our
customers use for getting into our system) in our database.
Instead he is using the VarChar dataType.
Can someone explain to me how I can exploit this
is there a way to instruct check table to check all tables without listing
each table in the sql statement?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I tried to download MySQL GUI from these links:
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
and
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz
But all these don't work.
Alex
- Original Message -
From: "Matthew Darcy" <[EMAIL P
There shouldn't be a space after -p , also don't forget to put the
user in there, unless you are using the default user (usually "root",
although i've noticed on win32 it seems to be 'ODBC')
ex: if your password is "test", the command would be
mysqladmin -u -ptest newpassword
By all means, cor
it's not all that dangerous. it just means that you can read your users'
passwords. anyone who can read that db table can become any of your
users. password fields are just another safeguard against a "just in case
someone gets read access to this" scenario. they also serve to provide
more pr
In the last episode (Dec 12), James McLaughlin said:
> The new programmer for our company is not using the dataType
> "password" or any encryption what so ever for our user accounts
> (accounts that our customers use for getting into our system) in our
> database.
>
> Instead he is using the VarC
Hi
3 months ago starting using mysql to archive a live news feed that our
company is paying for. Being a lazy unit, I am putting all the document
bodies into one table. After 3 months, that table has grown to 2G - so
its a natural enough assumption to assume that in another 3, it will
grow to
Just tell your boss that if you ever have turnover the former employee
will be able to log into all the customers' accounts and do whatever he
wants.
Dave
On Thu, Dec 13, 2001 at 03:29:41AM +1100, Duncan Maitland wrote:
> My questions concern a setup where a public server is running at our
> host
In the last episode (Dec 13), Tim Wood said:
> As mentioned above, I'm a lazy unit, so if possible would like to
> avoid restructuring the DB to spread the document body table across
> >1 table (thus enabling > 4 G of doc bodies), so am looking for some
> easier way to do it (eg upgrading mysql, o
Yes.
1. Read the manual sections concerning setting up new accounts with special emphasis
on passwords.
2. When you thoroughly understand those matters, take the issue to the system
administrator and/or management.
hth,
Doug
Only two things are infinite, the universe and human stupidity, an
How can I encrypt password in database and how can I retrieve the
encrypted password?
Thanks
ST Ooi
Malaysia
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "James McLaughlin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, December 13, 2001 7:06 AM
Subject:
As always with these things, horses for courses. In my situation,
I have a mysql server mounted off a netapp, It is the backend for
a website serving 10m+ page impressions per month.
I wanted to put the data on a netapp for easy backup ( I can shutdown
the server do a snapshot and bring it bac
you can use the password() mysql function to crypt it.
you cannot retrieve the encrypted password -- only compare input
(password() the input) against the saved encrypted password. if the
resulting text matches, the password is good. if not, the authentication
in your application should fail.
Hi.
On Wed, Dec 12, 2001 at 04:32:27AM -0700, [EMAIL PROTECTED] wrote:
> The MySQL documentation says:
>
> "To ensure that the update log/binary log can be used to re-create the
> original tables, MySQL will not allow concurrent inserts during INSERT
> SELECT"
>
> Does this mean:
Normally
> It's only dangerous if a customer can trick your web frontend
> into displaying the output of "SELECT * FROM USERS", for
> example. If the frontend only uses hardcoded queries, or
> quotes every user-supplied parameter, there's no problem. In
> fact, you need the password in plaintext to s
Hi.
On Wed, Dec 12, 2001 at 02:39:07PM +, [EMAIL PROTECTED] wrote:
> Hello
>
> I've got a problem selecting values that match an option from a SET column.
>
> My two columns are set up as follows:
>
> res_places SET('North','West','South')
> res_places_re SET('Aber
> In the last episode (Dec 13), Tim Wood said:
> > Does anyone out there know of any
> > - future plans by the mysql development crew to increase table size
> > limits by eg using their own custom filesystem type?
>
> You mean the MyISAM RAID table extension, or the Innodb tablespace
> format?
When you're insering a new password:
INSERT INTO user SET password=PASSWORD('secret');
But you can't retrieve the original password. If a user forgets/looses
his/her password, just reset a password with something else, and send
him/her that new password
And when you want to check an inputted p
My apologies, I was writing that from work, without immediate access to a
box running mysql. I tried it just now and have been having problems
attempting to put it into a config file. So far, I've only been able to get
it to work by passing --safe-show-database to the service as it starts.
If/when
Kelly,
If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file,
this will give you the same results at start up
[mysqld]
skip-show-database
This will then disable any user from viewing other databases they do not have
access too.
>On Wed, 12 Dec 2001 19:35:29 -0600, "Kell
I guess I gave up too quickly. Thanks for the info. :)
Kelly
- Original Message -
From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
To: "Kelly" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 7:35 PM
Subject: Re: Each user have only see databases they have
Taken from an email from Mike(mickalo)Blezien <[EMAIL PROTECTED]>
>If you use the 'skip-show-database' in the [mysqld] group in the my.cnf
file,
>this will give you the same results at start up
>[mysqld]
>skip-show-database
>This will then disable any user from viewing other databases they do not
> I guess I gave up too quickly. Thanks for the info. :)
>
> Kelly
>
> - Original Message -
> From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
> To: "Kelly" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, December 12, 2001 7:35 PM
> Subject: Re: Each user have only see da
1 - 100 of 115 matches
Mail list logo