ccess 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 remov
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 t
6/13/2003 -0500, 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
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]
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:
http://
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:
http://www.mysql.com/manual
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)
http:
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 thi
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 B.ActorI
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 d
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 posting
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
that works, try 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
>
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
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
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)
http://lists.mysql.
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 stateme
1) What is the correct select statement to use in MYSQL so that it only
shows the TitleName once and all the stars in a video. I have a search
button for Titles and when it gets submitted it shows it not the way I want it.
So if there is a Video with TitleName=I Spy and the stars are Eddie Murp
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 unl
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.
---
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? E
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, Ac
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
in
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 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 (F_Nam
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 dr
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 th
ve the GenreID from the control. You then
>pass this to the query, 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 th
e
>star), all the titles in a genre and even compound queries such as all the
>MGM thrillers featuring actor XYZ.
>
>hth,
>Arthur
>
>- Original Message -
>From: "John Chang" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, Octob
lize it.
>
>Greetings
>Michael
>
>At Montag, 14. Oktober 2002 14:49 John Chang wrote:
> > 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).
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
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.
33 matches
Mail list logo
