it.
At 10:43 AM 6/14/2003 -0500, you wrote:
At 1:53 -0400 6/14/03, John Chang wrote:
It worked!!. Thanks. Now how do I protect it so that not anyone who
points to it cannot get to it without putting in a username/password?
You seem to have an odd set of goals.
First, you want to remove
How do I set no password for root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, Paul DuBois wrote:
At 0:10 -0400 6/14/03, John Chang wrote:
How do I set no password for root?
mysql -u root -p
Enter password: (your current root password here)
mysql SET PASSWORD = '';
mysql quit
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL
It worked!!. Thanks. Now how do I protect it so that not anyone who
points to it cannot get to it without putting in a username/password?
At 12:24 AM 6/14/2003 -0500, John Nichel wrote:
John Chang wrote:
I changes the password but it still doesn't work. This is the error I
get when I try
I have a website that uses MYSQL, PHP, IIS, WMS4.1 on a win2k box. The
WMS4.1 is on a separate box and uses MyODBC to connect to MySQL. It only
does look up. On the other box that has MYSQL, PHP, IIS there is insert,
delete, select, etc. How do I secure MYSQL with NTFS permissions so that
I e-mailed the list but haven't received a response. I have win2k w/
3.23.53 and need to update it to 54. Is there a patch or do I have to do a
reinstall or install on top of it?
mysql
-
Before posting, please check:
Is there a patch update from .3 to .4? So that I don't have to reinstall it
on my win2k box? If I have to reinstall it do I need to first uninstall
.3 first?
mysql.
-
Before posting, please check:
In some of my tables I see overheard. What does it mean and does it mean I
have to optimize it every time? I seem to see it everyday. SQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Is there a website, book, or tips to secure and optimize MYSQL?
This is what my users look like:
Host Users PasswordPrivileges
localhost administratoryes has all priv.
localhost root yes has all priv.
Is
I am creating a search form for the TitleName. When I type in one word it
finds all titles with the one word. If I use two words it doesn't work.
How do I change my select statement to make it work? Thank you.
SELECT *
FROM Titles A, ActorTitle B, Actors C
WHERE A.TitleID=B.TitleID AND
How do I set the cache limit? Any suggestions on optimizing mySQL?
At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote:
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated
After I dump the database what is the command to import it into another
computer? Do I have to create a new database and then import all tables
and data or will it create the database, tables, and data?
MYSQL
-
Before
When MYSQL is being heavily used on a windows cpu, In Task Manager does the
memory cpu load increase show the use for mysqld or another process like
Explorer?
-
Before posting, please check:
http://www.mysql.com/manual.php
Where is the config file for MySQL on windows? Is that where I tell it to
use a log file? By default is it off? Thank you.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I just changed the root password for MYSQL from the default and now it
gives me the error Access is denied when I try to connect using
phpMyadmin. It doesn't even ask for a password. How can I login
in? Thank you.
-
Before
Is there a good or bad reason to create the config file in the MySQL folder?
On production servers which logs do you turn on?
Typically what things do you set on in the config file on a production server?
Thank you.
At 10:37 PM 11/12/2002 +0200, you wrote:
Hi!
On Tue, 12 Nov 2002, John Chang
resetting cookies from your browser, as phpMyAdmin
relies on cookie authentication.
Iikka
On Tue, 12 Nov 2002, John Chang wrote:
I just changed the root password for MYSQL from the default and now it
gives me the error Access is denied when I try to connect using
phpMyadmin. It doesn't even
I was reading through the docs and it says:
The following SELECT statements will not use indexes:
mysql SELECT * FROM tbl_name WHERE key_col LIKE %Patrick%;
mysql SELECT * FROM tbl_name WHERE key_col LIKE other_col;
I am using MYSQL on windows. So is that true?
When I use the below statement
If one cannot avoid using PHP how can I secure it? I will initially have
it on the same server as IIS.
At 10:40 AM 10/25/2002 -0500, Ed Carp wrote:
A quick question: Is phpmyadmin secure? Anyone have an negative
experiences
having it installed on their server?
PHP itself is not secure
I'm planning on using Win2k Adv. server, IIS, MYSQL, PHP on a dual
processor 2.4GHz processor with 1 or 2GB RAM, with either SCSI or ATA HDs.
The webpage will be dynamic.
1)How many concurrent connections would something like this handle?
2) Will it make a big difference if I use SCSI or ATA?
I am looking for an external drive case that will be connected to a Xeon
server with SCSI (Ultra-160) interface. I want something like 6-12
drives. Anyone have any suggestions? I do not want to go with Dell, IBM,
etc. They cost way too much. I just want one I can build. Thank you MySQL.
In MYSQL I'm using MYISAM. Should the 2 fields in each of the Stars
TitleGenres
table be Primary keys since they are 'tied' to other fields?
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID)
Actors (F_Name, L_Name,
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID)
Actors
What is the Title.ID and Actor.ID?
Will this work if someone is doing a text search on a webpage? The results
will go to another page. Does the below go to the first page or the
results page? Thank you.
At 12:20 PM 10/16/2002 -0400, you wrote:
John Chang wrote:
Studios (StudioName
I want to be able to create a Navigation bar on the left (Where I can do
searches, DropDown menu that performs an action) I want this in all my
pages but be able to modify it just once. On the right side I want a way
of dynamically getting data from a database and showing all searched item
SQL, Does it matter which table I enter data into first? Or do I need to
first
put in the data into Studios, Genres, Actors, Stars first before adding
to Titles and TitleGenres since they use the IDs of the other table? Or
should I convert it to type innodb and make the IDs foreign keys in
What I am trying to do is on the first webpage. There is a Studio dropdown
(information from the MySQL database) menu. When someone picks a studio
the results go to a different webpage showing just the movies in that
studio. How do I get the results onto the second page?
How can I do it in
, which would read something like this:
SELECT VideoTitle, TitleID FROM Titles
INNER JOIN TitleGenres ON Titles.GenreID = Genres.GenreID
WHERE Titles.GenreID = 3
Hope this helps.
For a search page that shows a list of titles by genre, say
-Original Message-
From: John Chang [mailto:[EMAIL
1) Is there a de facto type that is used? All I will be doing is creating
a database for use on the web for dynamic webpages. Basically doing
searches to the back-end MySQL database. I figure I don't need to use
transactional type since I will not be adding any information via a
front-end.
I've read a bunch about normalization in MySQL and still can't do it very
well. What I want to normalize is videos (Title, Studios, Actors, Genre,
bitrate).
These are the tables and fields I think it needs. Is this
normalized? Thank you.
Table (Fields)
Title (VideoTitle, details, id)
Studio
. ?
Normalization is a representation technique to
avoid storing *redundant* information. But first
this information has to be there. So first make the
design complete (in an unnormalized way, which fits
the problem), then in a *second* step normalize it.
Greetings
Michael
At Montag, 14. Oktober 2002 14:49 John
: John Chang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 14, 2002 8:49 AM
Subject: Normalization sql
I've read a bunch about normalization in MySQL and still can't do it very
well. What I want to normalize is videos (Title, Studios, Actors, Genre,
bitrate
32 matches
Mail list logo