Hello.
Try to connect as root (use -u root) or another user which has privilege to
create new databases.
I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I only have a normal user
privilege.
I have installed MySQL on my user UNIX
I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I only have a normal user
privilege.
I have installed MySQL on my user UNIX account.
Looks like I get the Server going and can also get the status from the
Server.
But, I get an error msg
Restart mysqld with the --skip-grant-tables option
and then try
Aman Raheja
Hossain, Ashfaq (Ashfaq) wrote:
Thanks.
But, it confuses the unix root with the mysql root.
I don't have the unix root previleges.
Am I doing something wrong?
Here is the error:
unix bin/mysql -uroot
ERROR 1045
]
Subject: MySQL Newbie: Running in UNIX
I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I only have a normal user
privilege.
I have installed MySQL on my user UNIX account.
Looks like I get the Server going and can also get the status
, December 01, 2004 12:57 PM
To: Hossain, Ashfaq (Ashfaq)
Subject: Re: MySQL Newbie: Running in UNIX
log in as root
mysql -uroot
then you are the boss
Aman Raheja
Hossain, Ashfaq (Ashfaq) wrote:
I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I
On Thu, 2004-07-08 at 00:19, Paul DuBois wrote:
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create
Sanjay Arora wrote:
On Thu, 2004-07-08 at 00:19, Paul DuBois wrote:
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am
Help please..I am not only a mySQL newbie but a SQL/DB newbie as well.
With regards.
Sanjay.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sanjay Arora mailto:[EMAIL PROTECTED]
on Wednesday, July 07, 2004 10:04 AM said:
I am using Mysql on RH Linux 9. I am getting the following error.
[snip]
Database changed
mysql GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD dns;
ERROR 1133: Password hash
At 22:34 +0530 7/7/04, Sanjay Arora wrote:
I am using Mysql on RH Linux 9. I am getting the following error.
Command and result are given below alongwith \s output for diagnostic
purposes.
I have created a dns database and am trying to create a user mysql user
dns with all privileges on it.
mysql
I wish to learn MySQL on my Linux box [SuSE 8.1]
Can I install MySQL on my hard drive and use it for learning *from* the
hard drive, without having to set up a server/network? This would include
MySQLCC.
In other words, can I run MySQL like Access, strictly as a local database,
for learning
Yes! Yes you can!
Ahem
Basically, MySQL is always a network-aware database whether connections
come in via Named Pipes (blame Bill for those), TCP/IP, UNIX sockets or
via the funky shared memory whatsit that was brought in with MySQL 4.1.x.
All that will be happening in your case is that
I am new to MySQL and have encountered a problem that probably happens
to everyone, yet I have searched for a solution online and elsewhere
without success. I created a database and table. Then I populated the
table. Everything worked perfectly. Then I shutdown MySQL and rebooted
my
Are the frm, myd and myi files located in the data directory? What is the
data directory?
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 8:43 AM
To: [EMAIL PROTECTED]
Subject: MySQL newbie: table gone after reboot
I am new to MySQL
PROTECTED]
Subject: MySQL newbie: table gone after reboot
I am new to MySQL and have encountered a problem that probably happens
to everyone, yet I have searched for a solution online and elsewhere
without success. I created a database and table. Then I populated the
table. Everything worked
Can you post the contents from the todo directory?
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:14 AM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
I am unfamiliar with frm, myd
, September 24, 2003 9:14 AM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
I am unfamiliar with frm, myd, and myi files, yet perhaps is
insightful?
-Avram
[aa:/usr/local/mysql] % ls -l data
total 41032
-rw-rw 1 mysql wheel 6362 Sep 23 22:55
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:37 AM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
Okay, I had to log in as root to do so. The data seems to be still
extant in tasks.MYD .
The other 2 files, tasks.MYI and tasks.frm
-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:37 AM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
Okay, I had to log in as root to do so. The data seems to be still
extant in tasks.MYD .
The other 2 files
permission to access the todo directory.
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 1:33 PM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
I have tried logging in as root ( mysql -p -u root
]
Sent: Wednesday, September 24, 2003 1:33 PM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
I have tried logging in as root ( mysql -p -u root todo )
and also as myself and both methods yield the same results, shown
below:
mysql SHOW TABLES FROM
David Shealy [EMAIL PROTECTED] wrote:
I don't know where the error log is. I used the -l option with
safe-mysqld and this is what I got:
/usr/libexec/mysqld, Version: 3.23.56-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld . Here's a copy of the shell output:
# safe_mysqld
[1] 7549
# Starting mysqld daemon with databases from /var/lib/mysql
030626
What does the error log say?
David Shealy wrote:
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld . Here's a copy of the shell output:
# safe_mysqld
[1] 7549
# Starting mysqld
I don't know where the error log is. I used the -l option with
safe-mysqld and this is what I got:
/usr/libexec/mysqld, Version: 3.23.56-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id CommandArgument
On Wed, 2003-06-25 at 15:40, gerald_clark
I'm interested in learning about MYSQL and wondered if anyone could give me
a few pointers for getting started.
I've designed over 1,000 webpages, based at http://www.geobop.com, but my
technical skills are very basic. I've been unemployed for about eight
months and have been using my time to
1) Can you recommend some good online tutorials for learning the basics of
MYSQL? (I can't even say I know exactly what it is; I think of it as some
sort of language used to create special effects or special functions,
similar to JavaScript.)
If you found this list then you should have found
you probably want php which intergrates into mysql nicely, as mysql being the
database for the content, http://www.php.net/
http://www.phpbuilder.com/
there is also some links on the php site u might want to check out
http://www.php.net/links.php
with mysql you prob want to master the sql
Hi, I just got involved into a project that uses MySQL. My team leader told
me that most likely we have to change the file inside the source code of
MySQL in order to use GSS API.
However, I am totally new to this area. I am wondering if there is any
resource that I can find on the internet or
Hi, my experience comes from VB6 with access databases.
I'am trying to get one quick and practical overview about the mySQL
capabilities (web online database).
But so far i'am really loss and confuse regarding the mySQL setup and
installation procedure. I'am using WIN98 with mySQL4.01.11 and
...and your problem is?
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: Fernando Martins [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 6:00 PM
To: [EMAIL PROTECTED]
Subject: mySQL newbie confusion
Hi, my experience comes from VB6 with access databases.
I'am
I'm confused John. Since --with-mysql=shared,/usr' appears in the
Configure Command table from phpinfo(), doesn't that mean php *was*
compiled with mysql support?
Ken
At 12:03 AM 11/5/2002 -0500, John Coder wrote:
On Mon, 2002-11-04 at 23:51, Ken Arck wrote:
then it's compiled under dbx
My problem is resolved. Apparently I was missing a package php-mysql.
Funny, no docs I found make mention of this.
In any case, I'm up and running. Thanks to all who offered help!
Ken
--
President - Arcom
On Tue, 2002-11-05 at 11:21, Ken Arck wrote:
I'm confused John. Since --with-mysql=shared,/usr' appears in the
Configure Command table from phpinfo(), doesn't that mean php *was*
compiled with mysql support?
Yes it was compiled with mysql support through tje dbx commands look at
the manual
Hi folks. I'm a real newbie to mysql (believe it or not!)
While just starting to get my feet wet in it, I've come across a huge
stumbling block already. I am familiar with php however.
A php script I'm playing with has this line:
$db = mysql_connect(localhost, root);
Here's the html output
On Mon, 2002-11-04 at 21:51, Ken Arck wrote:
Hi folks. I'm a real newbie to mysql (believe it or not!)
While just starting to get my feet wet in it, I've come across a huge
stumbling block already. I am familiar with php however.
A php script I'm playing with has this line:
$db =
At 10:32 PM 11/4/2002 -0500, you wrote:
What exactly do you mean by compiled in ? what does your phpinfo say.
You should have a section on mysql not just the line supported databases
mysql,pgsql,etc.
it reports mysql in two places:
In the Configure Command table:
On Mon, 2002-11-04 at 23:20, Ken Arck wrote:
At 10:32 PM 11/4/2002 -0500, you wrote:
What exactly do you mean by compiled in ? what does your phpinfo say.
You should have a section on mysql not just the line supported databases
mysql,pgsql,etc.
it reports mysql in two places:
then it's compiled under dbx functions not mysql functions run
configure again with the same arguments except for mysql just run
--with-mysql and it should be ok.
-As I said, it was installed from an rpm as part of the Redhat install
package and not from a tarball. Are you saying to
On Mon, 2002-11-04 at 23:51, Ken Arck wrote:
then it's compiled under dbx functions not mysql functions run
configure again with the same arguments except for mysql just run
--with-mysql and it should be ok.
-As I said, it was installed from an rpm as part of the Redhat install
I would appreciate it if some one can do a hand hold on this one. I need to convert
from Access to mysql but still using MS Access Front End, I understand this is done
via ODBC link to the mysql server and this is my problem. Due to my lack of command
line knowledge and no GUI on the Cube for
This has probably been asked a thousand times before but only once from me.
I am able to programme in MS Access to quite a high level to which I have now realised
its limitations, where is the best place to start learning and reading up on MYSQL, I
am not really a book reader as I prefer to do
On Mon, 28 Oct 2002 [EMAIL PROTECTED] wrote:
This has probably been asked a thousand times before but only once from me.
I am able to programme in MS Access to quite a high level to which I have now
realised its limitations, where is the best place to start learning and reading up on
MYSQL, I
This has probably been asked a thousand times before but only once from me.
I am able to programme in MS Access to quite a high level to which I have now
realised its limitations, where is the best place to start learning and reading up on
MYSQL, I am not really a book reader as I prefer to do
the manual is a very good place to start , its very organized , and its complete
reference , better than any book .
trial and error is good , but try to get a graphical user interface beter than the
shell . there are many .
--- [EMAIL PROTECTED] wrote:
This has probably been asked a thousand
Very new to MySQL and I've done a search on
google.com, but really couldn't find the answer that I
am looking for.
Where should I install MySQL? I'm running RH 7.3 and
I've installed the tgz file under my directory
/home/CMMiller, is this right, or anywhere else? I
see it is also under
CM Miller wrote:
Very new to MySQL and I've done a search on
google.com, but really couldn't find the answer that I
am looking for.
Where should I install MySQL? I'm running RH 7.3 and
I've installed the tgz file under my directory
/home/CMMiller, is this right, or anywhere else? I
see it is
* Mylin Campos
I'm a newbie with mysql. I have a few question and would really
appreciate it if you can help me. I'm creating a database for a
payroll system. I actually finish with my entity relationship
diagram. What should be the next step? I know I should create
the database already but
Hello,
sorry for a late answer, but here it comes.
On Tue, 27 Aug 2002, Mylin Campos wrote:
I'm a newbie with mysql. I have a few question and would really appreciate
it if you can help me. I'm creating a database for a payroll system. I
actually finish with my entity relationship diagram.
Mylin,
Tuesday, August 27, 2002, 8:17:13 AM, you wrote:
MC I'm a newbie with mysql. I have a few question and would really appreciate
MC it if you can help me. I'm creating a database for a payroll system. I
MC actually finish with my entity relationship diagram. What should be the
MC next
Hi all,
I'm a newbie with mysql. I have a few question and would really appreciate
it if you can help me. I'm creating a database for a payroll system. I
actually finish with my entity relationship diagram. What should be the
next step? I know I should create the database already but while
Hi all,
I'm a newbie with mysql. I have a few question and would really appreciate
it if you can help me. I'm creating a database for a payroll system. I
actually finish with my entity relationship diagram. What should be the
next step? I know I should create the database already but while
* marc malacarme
I can¹t seem to make any of the describe or show queries work
when I apply a search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like user_access;
Does no work.
The
Hrm. Closest I can think of is
EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';
I think this is what you mean.
Adam Hooper
[EMAIL PROTECTED]
On Fri, 31 May 2002 08:44:49 -0700
marc malacarme [EMAIL PROTECTED] wrote:
I can¹t seem to make any of the describe or show queries work when
marc,
Friday, May 31, 2002, 6:39:54 PM, you wrote:
mm I can¹t seem to make any of the describe or show queries work when I apply a
mm search statement:
mm Query=show table status from demo;
mm Works fine. Now I¹m trying to get info from only one table:
mm Query=show table status from demo where
I can¹t seem to make any of the describe or show queries work when I apply a
search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like user_access;
Does no work.
Thank You
I can¹t seem to make any of the describe or show queries work when I apply a
search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like user_access;
Does no work.
Thank You
Hrm. Closest I can think of is
EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';
I think this is what you mean.
Adam Hooper
[EMAIL PROTECTED]
On Fri, 31 May 2002 08:44:49 -0700
marc malacarme [EMAIL PROTECTED] wrote:
I can¹t seem to make any of the describe or show queries work when
--
www.girishnath.co.uk
- Original Message -
From: Ben Clumeck [EMAIL PROTECTED]
To: Girish Nath [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2002 1:51 AM
Subject: RE: [PHP] MySQL Newbie
I am under the understanding that anyone who has shell can access my
database and view all information
Hello, and sorry for the bother with what is probaby a very simple problem.
I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the
included distribution of MySQL, which is version 3.23.41
When I try to run the mysql program, either by itself, or with any
arguments, I get
did you start mysqld ?
-Original Message-
From: David Burklin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:36 PM
To: '[EMAIL PROTECTED]'
Subject: MySQL newbie question
Hello, and sorry for the bother with what is probaby a very simple problem.
I'm new to MySQL. I
running, so that's the big part of my problem.
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:44 PM
To: David Burklin; '[EMAIL PROTECTED]'
Subject: RE: MySQL newbie question
did you start mysqld ?
-Original Message-
From
On Wednesday 16 Jan 2002 7:36 pm, you wrote:
Hello, and sorry for the bother with what is probaby a very simple problem.
I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the
included distribution of MySQL, which is version 3.23.41
When I try to run the mysql program,
This did the trick. Thanks Nod and everyone else!
-Original Message-
From: nod [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 2:02 PM
To: David Burklin
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie question
On Wednesday 16 Jan 2002 7:36 pm, you wrote:
Hello, and sorry
Hello all, I just start up with mysql so I have some stupid questions to
ask.
right now I have an MS Access database with one table that has 25 fields
and like 2000 records in it. I'm trying to move to MySQL in order to
have a better DB. I can define the database and the table manually
that's
Hi Jose,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose
Gerardo Amaya Giron
Sent: Thursday, November 22, 2001 1:11 PM
To: [EMAIL PROTECTED]
Subject: MySQL Newbie and Access Database
Hello all, I just start up with mysql so I have some
Greetings
I teach beginning programming to High School students at Pasco High in
Pasco, WA.
I recently went to receive some training at the Oracle Internet Academy
in California and
found Oracle to be a big stretch for me and my students.
We've downloaded MySQL and the MySQL client.
We
Hi,
Is their another gui I could use to populate a mySQL database?
my personal opinion - the best MySQL GUI by far I've seen
is the EMS MyManager: http://ems-hitech.com/mymanager/
Rgds,
Indrek
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/
Hi,
I've just downloaded and install mySQL on my server but only seem able to
connect to the server across my network if the server is connected to the
internet. Any ideas why and how to stop it. btw I'm running windows.
TIA
Alex
: Re: Using Scripts with MySQL - NEWBIE
At 7:31 PM +0100 7/11/01, Sara wrote:
Hi
I am using Paul Dubois' book MySQL to teach myself. He has sample
data base data which one can load using his scripts.
However, the book doesn't say where the scripts have to be loaded to
inorder for them
At 9:13 PM +0100 7/13/01, Sara wrote:
Hi Paul
Thanks for replying, however, something which I know should be easy is
eluding me right now.
The samp_db directory is created as a subdirectory of the mysql1 directory.
This is what I tried to do following your instructions and this is the error
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Sara [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 13, 2001 9:20 PM
Subject: Re: Using Scripts with MySQL - NEWBIE
At 9:13 PM +0100 7/13/01, Sara wrote:
Hi Paul
Thanks for replying, however, something which I
At 9:54 PM +0100 7/13/01, Sara wrote:
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Sara [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 13, 2001 9:20 PM
Subject: Re: Using Scripts with MySQL - NEWBIE
At 9:13 PM +0100 7/13/01, Sara wrote:
Hi Paul
Thanks
Hi
I am using Paul Dubois' book MySQL to teach myself. He has sample data base data
which one can load using his scripts.
However, the book doesn't say where the scripts have to be loaded to inorder for them
to work ie which directory?
Also can someone just confirm the syntax for a create
just do:
mysql -f script_name.extension
That'll do it.
Mike B.
-- Original Message --
From: Sara [EMAIL PROTECTED]
Date: Wed, 11 Jul 2001 19:31:48 +0100
Hi
I am using Paul Dubois' book MySQL to teach myself. He has sample data base data
which one can
At 7:31 PM +0100 7/11/01, Sara wrote:
Hi
I am using Paul Dubois' book MySQL to teach myself. He has sample
data base data which one can load using his scripts.
However, the book doesn't say where the scripts have to be loaded to
inorder for them to work ie which directory?
Also can someone
Hi there,
I'm trying to install MySql and Mysql client
(including MySql GUI) both on Windows and Unix/Linux.
I'm having trouble reset the root password:
I ran:
./bin/mysqladmin -u root password 'mysqlroot'
./bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user:
Does anyone know exactly where to put the mysql.server file? is it in /etc? When I
run it I get these
./mysql.server: @HOSTNAME@: command not found
./mysql.server: my_print_defaults: command not found
Which leads me to believe I'm doing somthing wrong.
Hi
I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box.
When I try to contact the mysql server i get the following error:
[someone@somemachine ~]$ mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
Hi
I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box.
When I try to contact the mysql server i get the following error:
[someone@somemachine ~]$ mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
TCPwrappers has nothing to do with mysql.
Mysqld manages the port itself.
You do not want tcpwrappers grabbing the port.
Check the path to mysql.sock.
It must be world searchable and readable for the client to write to the
socket.
Read the section of the manual on GRANT privileges.
You are not
81 matches
Mail list logo