Neil Tompkins wrote:
The problem appears to be retrieving the data which is slow.
Are you sure it's not the actual query that's slow?
If you run the query in mysql (ie through the command prompt) is it fast?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
of this remote update, would we see a problem if we
queried the mysql database from webpages from another ISP ?
Date: Thu, 10 Aug 2006 16:09:29 -0500 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] Subject: Re: Access mySQL database across Internet CC:
mysql@lists.mysql.com A good point to make here
on our local Internet connection from our own office
network. We have seen no performance issues from our websites hosted by the
same ISP running our mySQL server.
My question is because of this remote update, would we see a problem if we
queried the mysql database from webpages from another ISP
On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote
At the moment our mysql server hosted by an ISP, is updated every
second by a program running on our local Internet connection from
our own office network. We have seen no performance issues from our
websites hosted by the same ISP
with yours - would
be disappointing for sure to build it all then get a call saying
cease and desist; read our acceptable use policy.
Dan
On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote:
Hi
We have a mysql database hosted with a IIS server on the same network
accessible over the Internet. Now we
What would you assume to be high traffic ? 1000 hits per day or more ?
Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] Subject: Re: Access mySQL database across Internet CC:
mysql@lists.mysql.com Neil, in theory, this should work fine, given
sufficient
, then you're talking high traffic!
Dan
On 8/10/06, Neil Tompkins [EMAIL PROTECTED] wrote:
What would you assume to be high traffic ? 1000 hits per day or more ?
Date: Thu, 10 Aug 2006 13:05:11 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC
] To: [EMAIL PROTECTED] Subject: Re: Access mySQL database across Internet CC: mysql@lists.mysql.com Neil, in theory, this should work fine, given
sufficient bandwidth between the two sites. In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling
.
Reconfigure, recompile, and test.
Thanks
Visolve DB Team.
- Original Message -
From: khaing su yee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 01, 2006 9:28 AM
Subject: want to insert unicode myanmar characters into MySQL database
I use Toad for MySQL 2.0 and SQLyog
I use Toad for MySQL 2.0 and SQLyog 5.02.
I want to insert unicode myanmar characters.
I change uft8 charset and utf8_unicode_ci collation.
But I can't insert myanmar characters.
What is needed to do?
Please tell me.
Thanks
--
MySQL General Mailing List
For list archives:
/mysql_install_db --user=mysql
After that I started the mysql server: /opt/mysql/mysql/bin/mysqld -u mysql
At this point I run the command mysqlshow in order the check the granted
databases: I can see both the information_schema and test databases, but I
am missing the mysql database.
What am I
I am a phpmyadmin user and have never really used mysql query browser before. I
have a database sitting on my localhost and I want to export the whole thing
via mysql query browser to the host. What is the easiest way to do it?
Ross
[EMAIL PROTECTED] wrote:
I am a phpmyadmin user and have never really used mysql query browser before. I
have a database sitting on my localhost and I want to export the whole thing
via mysql query browser to the host. What is the easiest way to do it?
Ross
Use the MySQL admin tool, not
Vinay,
- Original Message -
From: Vinay [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 02, 2006 12:20 AM
Subject: Enforcing Isolation in MySQL database
--=_NextPart_000_002C_01C63D51.B51315D0
Content-Type: text/plain;
charset=iso-8859-1
Content
Hello ,
I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the
default isolation. Is the concurrency enforced automatically by the database or
is there anything
the application programmer has to do to make sure the data consistent.
How does the REPEATABLE-READ resolve the
- Original Message -
From: Vinay
To: mysql@lists.mysql.com
Sent: Wednesday, March 01, 2006 5:00 PM
Subject: Enforcing Isolation in MySQL database
Hello ,
I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the
default isolation. Is the concurrency enforced
Hi all
I am working with startup company.
Have some quries about Mysql
1. What is the maximum database storage capacity of mysql
2. What is the maximum row capacity?
3. How much time it will take to search the record if there are consider more
than 1 billion rows in a table
4. How many records
Australia
invent
---
-Original Message-
From: vishwas kharajge [mailto:[EMAIL PROTECTED]
Sent: Monday, 9 January 2006 8:05 PM
To: mysql@lists.mysql.com
Subject: Mysql database
in a single table.
Regards
sujay
-Original Message-
From: vishwas kharajge [mailto:[EMAIL PROTECTED]
Sent: Monday, January 09, 2006 3:05 PM
To: mysql@lists.mysql.com
Subject: Mysql database capacity
Hi all
I am working with startup company.
Have some quries about Mysql
1. What
-
From: vishwas kharajge [mailto:[EMAIL PROTECTED]
Sent: Monday, January 09, 2006 3:05 PM
To: mysql@lists.mysql.com
Subject: Mysql database capacity
Hi all
I am working with startup company.
Have some quries about Mysql
1. What is the maximum database storage capacity of mysql 2. What
-Original Message-
From: vishwas kharajge [mailto:[EMAIL PROTECTED]
Sent: Monday, January 09, 2006 3:05 PM
To: mysql@lists.mysql.com
Subject: Mysql database capacity
Hi all
I am working with startup company.
Have some quries about Mysql
1. What is the maximum database storage
Hi,
I'm sure this is a stupid question, but I haven't been able to find
it myself. Surely there must be a free PHP utility to
web-administrate a MySQL database? I use CocoaMySQL
(http://cocoamysql.sourceforge.net/) on my own Mac, but it isn't
suitable for online databases. Can anyone lead me
@lists.mysql.com
Subject: MySQL database design documentation
Hi,
I'm sure this is a stupid question, but I haven't been able to find
it myself. Surely there must be a free PHP utility to
web-administrate a MySQL database? I use CocoaMySQL
(http://cocoamysql.sourceforge.net/) on my own Mac
I'm coding Stored Procedures in MySQL and as a precaution I want to trap
any potential database errors thrown by MySQL. Does MySQL offer specific
system variables that you can interrogate in an if test and take action
accordingly?
Please let me know.
Thanks,
Brandon
--
MySQL General
I'm coding Stored Procedures in MySQL and as a precaution I want to trap
any potential database errors thrown by MySQL. Does MySQL offer specific
system variables that you can interrogate in an if test and take action
accordingly?
Please let me know.
,
what is the maximum no of tables supported in a mysql database?
That mostly depends on how large your hard drives are...
Except for the InnoDB engine (in default mode) and the NDB engine, all other
database engines use 1 or more files per table. How many individual files
fit on your hard
(2.6 kernel) operating system assuming i have
that much hard disk space?
On 12/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 12:10:52 AM:
hi,
what is the maximum no of tables supported in a mysql database?
That mostly
on 12/11/2005 12:10:52 AM:
hi,
what is the maximum no of tables supported in a mysql database?
That mostly depends on how large your hard drives are...
Except for the InnoDB engine (in default mode) and the NDB engine,all
other
database engines use 1 or more
hi,
what is the maximum no of tables supported in a mysql database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 12:10:52 AM:
hi,
what is the maximum no of tables supported in a mysql database?
That mostly depends on how large your hard drives are...
Except for the InnoDB engine (in default mode) and the NDB engine, all
other database engines use
kbforge.com is pleased to announce the first public release of kbforge,
a new free desktop search application specifically designed for software
developers.
What differentiates kbforge from other desktop search programs, is its
ability to assist the user in categorising the information before it
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3, which was easy. I've installed Perl support for MySQL,
which was suprisingly difficult. I've installed CocoaMySQL
(http://cocoamysql.sourceforge.net/) to create, inspect and backup
databases. And now I'm
- Original Message -
From: Maurice van Peursem [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac OSX
10.3, which was easy. I've
A couple of good links for databases.
Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side
SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced:
Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206
The original edition was my first primer on relational databases. It was
an excellent read.
Ben
Maurice van Peursem wrote:
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3,
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,
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 the databases I have defined
[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
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 the databases I have defined. In effect,
it seems as though I have no real root (or administrator level, if
that's
Hello.
Reading these parts of the manual could answer a lot of questions:
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
http://dev.mysql.com/doc/refman/5.0/en/GRANT.html
Xiaobo Chen wrote:
Hi, all
I am trying to find out how to check which user is connecting to
Hi, all
I am trying to find out how to check which user is connecting to the
server from which host.
I have a database, data_A; I wrote a simple java code to connect this
database as user 'root', then it just waits there for input from the
keyboard. Before I type anything, it should keep
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
I have a database, which is more than 120GB with about 500 million
records. MySQL works well.
Andrew stolarz wrote:
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
--
Chenzhou Cui
Andrew stolarz wrote:
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
The answer to that question depends more on your OS than mysql. A quick
search of the contents page of the documentation clearly list the
limitations of this kind.
--
Chris W
and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database |
+--+
| mysql|
| test
-system.html and
http://dev.mysql.com/doc/mysql/en/user-account-management.html
regards
On 2005Äê08ÔÂ20ÈÕ 14ʱ46·Ö26Ãë, tai huijia wrote:
Greetings,
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database
Greetings,
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database
tai huijia wrote:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
You need to log in (to MySQL) as root if you want to see the mysql
database. It contains sensitive information
--- Jasper Bryant-Greene [EMAIL PROTECTED]
wrote:
tai huijia wrote:
You need to log in (to MySQL) as root if you want to
see the mysql
database. It contains sensitive information which
will only appear to root.
check your my.cnf or ini file and check for this
parameter:
safe-show
Hi there,
Is the mysql database always in UTF8 characterset for MySQL 4.1 and up?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 12 August 2005 10:43
To: mysql@lists.mysql.com
Subject: mysql database characterset
Hi there,
Is the mysql database always in UTF8 characterset for MySQL
4.1 and up?
With regards,
Martijn Tonies
Hi there,
I have a MySQL 4.1 DB running including a database whose character set
is set to utf8.
In the database I have a table tblmembers with some records containing
german umlauts.
How do I sort results with german umlauts if the database character set
is set to utf8?
Using the SQL query
Nico Grubert [EMAIL PROTECTED] wrote on 22/07/2005 09:06:25:
Hi there,
I have a MySQL 4.1 DB running including a database whose character set
is set to utf8.
In the database I have a table tblmembers with some records containing
german umlauts.
How do I sort results with german umlauts
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop
You could try:
SELECT memberid, lastname
FROM tblmembers
ORDER BY lastname COLLATE latin1_german2_ci ASC
It worked in my database. But I dont know, if my database is utf8.
By the way: Perhaps you could tell me how I can determine/change the encoding
of the database?
Kind regards
Christian Wollmann wrote:
By the way: Perhaps you could tell me how I can determine/change the encoding
of the database?
SHOW CREATE DATABASE db_name;
ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name];
On Saturday 23 July 2005 09:05am, Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysql from trying to
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop
as the database
platform as it is free. The MySQL database is hosted on a
dedicated server that has been purchased from a web hosting company.
This database would be used both by our customers and by our own
employees.
The first column will contain some text which will be unique in each
row. 90
Hallo,
after creating a user via the grant command, I found that this new user
can see by the 'show database' command the mysql database although the
grant does not apply to it.
This new user can run the 'use mysql' command, but has no access to the
tables.
The db table only show access grants
Harald Falkenberg wrote:
Hallo,
after creating a user via the grant command, I found that this new user
can see by the 'show database' command the mysql database although the
grant does not apply to it.
This new user can run the 'use mysql' command, but has no access to the
tables.
The db
Hi All,
I had posted a query few days back that I couldn't connect to mysql database
from a network machine. So for that I added two entries in my firewall
exceptions.
I added the Port 3306 and mysqld, so firewall should allow any connection to
database from external computer. My problem
Hello.
Error 2013 means: Lost connection to MySQL server during query. See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
rtroiana wrote:
Hi All,
I had posted a query few days back that I couldn't connect to mysql
database
from a network machine. So for that I
Hello.
with php scripts. Now I am getting the message Unable to load database
indicated by configuration file or something similiar when trying to connect
to
any database running on the server when the mysql user is running @localhost.
Please, send the exact error messages and
Are your php scripts by any chance called phpWebSite? If so, you might
find more help here:
http://www.phpwsforums.com/
What you're getting is almost definitely a PHP script catching some kind
of error trying to connect to the database server. You should have a
file called configure.php or
Greetings all,
Im new to mysql and have inherited several mysql databases and everything has
been going well until lately. Most of my webpages come from mysql databases
with php scripts. Now I am getting the message Unable to load database
indicated by configuration file or something similiar
hi
I have a huge mysql database on the live server. Every 15 days few 1000 records
change in that database [additions/updations/deletions]
I don't want to upload the entire mysql database every 15 days as the file size
is huge. Is there anyway for me to just upload the delta data and use some
Hello.
MySQL supports incremental backups. See:
http://dev.mysql.com/doc/mysql/en/backup.html
BG Mahesh [EMAIL PROTECTED] wrote:
hi
I have a huge mysql database on the live server. Every 15 days few 1000 rec=
ords change in that database [additions/updations
Hi,
We are developing an application that needs to use a massive back-end
database. The database will contain around 75 million rows with around
80 columns per row. We would prefer to use MySQL as the database
platform as it is free. The MySQL database would be hosted on a
dedicated server
I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
path and database creation directory is /var/lib/mysqlnow there is a
a dearth of space in /var therefore i would like to move the database
files to something like /usr which has lots of free space , creating
Symlinks does not
On Monday, March 07, 2005 22:19, digvijoy chatterjee wrote:
I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
path and database creation directory is /var/lib/mysqlnow there
is a a dearth of space in /var therefore i would like to move the
database files to something
Hi,
Have you try google ?
http://www.google.fr/search?hl=frq=storing+image+in+mysqlbtnG=Recherche+Googlemeta=
I see pretty much a lot of stuff there ;)
btw, storing image in a table in considering a bad practice, let the
filesystem handle it it does it more efficiently. I would suggesdt to
write
Hello list-
I am programing both in Java and PHP. Can anyone point me to sample
code for either on saving an image to a table?
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear member,you can visit:
http://dev.mysql.com/doc/connector/j/en/index.html
http://dev.mysql.com/doc/mysql/en/php.html
Hello list-
I am programing both in Java and PHP. Can anyone point me to sample
code for either on saving an image to a table?
Thanks,
-Chris
--
MySQL General Mailing
hi,
1. i have same problem.
SPEC :
winxp sp2 + recent security bug patch.
mysql 4.1.9.
the docs :
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
just doesnt't worked.
snip
At the DOS command prompt, execute this command:
C:\ C:\mysql\bin\mysqld-nt --skip-grant-tables
/snip
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question is: Is there a way of querying MySQL not for values of
fields, but rather
You mean show databases, show tables and describe $table_name for
every table in the database ?
Balazs
On Wed, Feb 02, 2005 at 10:31:17AM -0800, Dan Stromberg wrote:
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared
Dan Stromberg [EMAIL PROTECTED] wrote on 02/02/2005 01:31:17 PM:
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question
of a unknown MySQL database?
I have a system with set of web pages that use PHP and a
MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question is: Is there a way of querying MySQL
PROTECTED]
Subject: Pulling a database schema out of a unknown MySQL database?
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has been
hired. She needs to know the schema of the database.
So my question is: Is there a way of querying MySQL not for values of
fields, but rather
The easiest route is to use mysqldump with the --no-data option. it
will dump the full schema info including feign keys, etc.
-- michael dykman
On Wed, 2005-02-02 at 13:31, Dan Stromberg wrote:
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back
into that database and restore my mistake?
Thanks,
jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
[snip]
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back into
that database and restore my mistake?
[/snip]
Stop the mysql serivce, then start it from a command line with the
skip-grant-tables option. You
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
Jay Paulson [EMAIL PROTECTED] wrote:
Like an idiot I locked myself out of the mysql database when I went to
change the password for the root user. Is there any way I can get back
into that database
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and user creation.
3. Exit
My script file should have
mysql -u root
create database mnms;
user creation command
The script
[EMAIL PROTECTED] wrote:
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and user creation.
3. Exit
My script file should have
mysql -u root
create database mnms;
user creation command
The
The -e option with mysql allows you to run queries and would allow doing
user creation etc as well.
Aman Raheja
[EMAIL PROTECTED] wrote:
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and
Okay, extreme newbie. I probably just missed it but I went to the mysql site to
download the database so that I could use it at work and I am having a problem
finding it. The spot I expected it to be in there wasn't a link for it.
Anybody got any ideas?
~Melanie~
[snip]
Okay, extreme newbie. I probably just missed it but I went to the mysql
site to download the database so that I could use it at work and I am
having a problem finding it. The spot I expected it to be in there
wasn't a link for it.
Anybody got any ideas?
[/snip]
Try here
I hope you went at least to www.mysql.com ;)
- Second tab Developer Zone.
- First tab Downloads from the second menubar.
- Select version of your database
- Select your OS
- Pick a mirror
- Have fun
Rik
Op donderdag 16 december 2004 14:28, schreef Serenity Schindler:
Okay, extreme newbie. I
Hi,
I used mysqldump to recreate the a DB in another machine:
% mysqldump -A -u root --opt -p backup.sql
But I guess that duplicates some columns in the mysql database, `cause
when want to add a new user to a new database:
mysql grant all on some_db.* to [EMAIL PROTECTED] identified by 'pwd
Hi,
After I installed rpm packages on my system, I am unable to connect to the
databse. I have installed in the following order
1)Server
2)Client
3)Devel
4)Shared Compat
After starting the databse with:
/etc/rc.d/init.d/mysql start
I am unable to login as:
/usr/bin/mysqladmin -u root
Hi,
Most likely your MySQL has no password for root in the default instalation.
Try:
# mysql -u root -p
and simly press enter when asked for the password.
Worked ?
Alright, so now it's time to give root a password:
# mysqladmin -u root password 'my_secret_password'
That's all that there is to it
Hi, all
I would like to know is there anyway where i can
connect to the mysql database without add the odbc dsn ?
which i want to direct access to the mysql
database.
i wish to create 1 dsn, and by using this dsn, i
able to access all database,
even able to create/delete the mysql database
database
without add
the odbc dsn ?
which i want to direct access to the mysql database.
i wish to create 1 dsn, and by using this dsn, i able to access all database,
even able to create/delete the mysql database.
is there anyway to do that ?
Thanks. alice [EMAIL PROTECTED] wrote
Yup, Thanks a lot.
This is exactly the solution what i want.
Thank you very much. :)
- Original Message -
From: Kardos Andrs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 5:20 AM
Subject: Re: Direct connection to mysql database
You can use one DSN
Hi!
I'm looking for a good graphical database designer, supporting
the latest stable release of MySQL, MyISAM and InnoDB tables and
foreign keys. So far there are a lot of products. But I need one,
which runs on Windows and MacOS X. Do you have a good suggestion?
Regards,
Andreas
--
MySQL
Have you tried DBDesigner4 by fabForce?
Andreas Ahlenstorf wrote:
Hi!
I'm looking for a good graphical database designer, supporting the
latest stable release of MySQL, MyISAM and InnoDB tables and foreign
keys. So far there are a lot of products. But I need one, which runs
on Windows and MacOS
101 - 200 of 726 matches
Mail list logo