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
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
Fix your mysql privileges
http://dev.mysql.com/doc/mysql/en/GRANT.html
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: Hossain, Ashfaq (Ashfaq) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 8:39 AM
To: [EMAIL PROTECTED]
, 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
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
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
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
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 aa.local..err
-rw-rw 1 mysql wheel 25088 Sep 8 00:43
ib_arch_log_00
-rw-rw 1 mysql wheel
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
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
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
...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
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
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
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
* 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
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
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
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
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/
__ ___ ___ __
/
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
49 matches
Mail list logo