You could look into parted to resize partitions or copy the db to the
desired directory and restart the damon with safe_mysqld
--data-dir=/where/u/moved/db/to. I believe you'll also need to copy
over the mysql database to the new location as well or mysql will fail
to start. first, note your per
Just jumping in here so take this info accordingly.
Do you have root access to this machine?
If so, try restarting with --skip-grant-tables and set up your perm
scheme.
Look into mysqlaccess what does it say for root localhost ?
You can also replace user, host, db with '%' to see all possi
If you installed correctly and it's running then you likely forgot to
add the '/' at the end of the phpmyadmin part i.e.
youriphere/phpmyadmin/ not yourip or localhost/phpmyadmin.
justin
-Original Message-
From: Aqua [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 7:42 PM
To: [
This seems like a dumb question--sorry. Looking at my table it shows
'MUL' instead of 'PRI' like the other tables. Did I forget to code
unit_id as primary? Thanks, Justin
mysql> desc property_units;
++-+--+-+-++
| Field | Typ
ting it in notepad
before I copy it over into my insert into properties (bulletpoints)
values ('paste from notepad');
Maybe there's a better way since the above seems cumbersome.
Regards, justin
-Original Message-
From: justin cunningham [mailto:[EMAIL PROTECTED]]
Sent: T
How do I delete data from a table? I tried the man pages for delete and
replace but there not working. I have a table with 8 rows. The table
is called properties. The row is called bulletpoints. i tried deleting
and replacing the fuged data and sql says ok bla but when I select
bulletopints f
Try 'mysqlaccess root localhost' and see if there is a password set in
the output.
Try man mysqladmin and set the password there.
If you've hosed your perms then stop the damon and restart it with
--skip-grant-tables and start again.
Remember to do mysqladmin reload or flush privileges from
Thanks!
I'll choose option A since i'm being paid to build a database (now I'm
behind;( not reinstall sql and debian's woody will be pushed into stable
soon (along with mysql-server 3.23.49-8 etc which is the point of going
with debian). Thanks again!
-justin
-Original Message-
Fr
this is the version packaged with the stable branch of debian. Thanks,
justin
oba:~# mysql -V
mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686)
oba:~# mysqladmin -V
mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
oba:~# mysqladmin ver
mysqladmin Ver 8.19 Distrib 3.23.37,
exactly.mysqladmin -V
mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
this and every other command in mysqladmin work except for create and
drop. dunno why. I'd like to get on to building databases instead of
permissions over and over.
I ssh into the box. User/pass are sa
ect: Re: what causes this error
Justin,
The error message states that you have a syntax error in the CREATE
DATABASE statement. This is probably just a typo, but the only way for
us to diagnose the problem is for you to post the exact statement that
gives you the error.
-myk
jus
mysqladmin: CREATE DATABASE failed; error: 'You have an error in your
SQL syntax near 'whateverunamethedatabase'
I can complete every function with msyqladmin except create and drop.
What am I doing wrong. I've read all the docs online, sent similar
emails with no response. This is not an acce
I believe that's modify. Check man page.
Alter table yourtablename MODIFY yourfieldname varchar (25) (or whatever
) not null default 'no comment'
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 7:37 AM
To: MySql Mail List
Subject: changing col
I've sent similar questions to the list with no replies so here's the
best I can do for you.
I use debian so I dunno what's specific to it beyond the created user to
start and stop the damon so; try
mysqlaccess user host db to see what privileges you've got.
u can restart msyql or safe_mysql
Hi list, can someone here give me a quick and dirty example of how there
connecting to a database via sockets? I see the data in the man page
but I'm uncertain as to implementation. Thanks, justin
Sql,query
-
Before posting,
Thanks for the reply! Should I change the structure such that all
varchar fields are in the same table?
I believe you did understand my design correctly. Available_properties
contains the primary data. Property names is just a table that contains
subsequent data for available_properties and de
Hello list, this is my first table for a simple php page and I'm hoping
someone could briefly review its structure. The only fields I'll be
sharing are property_name and type. Are they set up properly for select
join queries?
thank you, justin
Database=properties
Tables are available_properti
I created two users with grant; obdba with select,insert,index,file and
other privileges and obdbu with select only privileges. Flushed
privileges. Mysqlaccess shows the correct perms for database
'properties' (the only database) for each user although when I try
logging in as either user to tes
18 matches
Mail list logo