On Thu, Nov 4, 2010 at 5:13 AM, Christoph Boget
wrote:
> I think
> it might be time to start seriously looking at Postgres...
Even though all the info you provided is extremely
exaggerated...switching all my databases to PostgreSQL has been the
best thing I've done in years. It's IMO far superior
I have an existing table with a few columns I created a few months
ago. Sadly I left out the column I would like to use for my Primary
Key and wanted to know what is the best way to add a column to an
existing table but also I want the column to appear first before any
other columns since it's the
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent wrote:
> Get this tool: http://sqlyog.com/ it rocks.
>
> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
I can't use any graphical or 3rd party add-on's. I was hoping MySQL
had this native / built in. I guess not...
--
My
I am new to MySQL coming from PostgreSQL & noticed a really annoying
issue. When I select a database, and try to auto complete in MySQL, it
doesn't capitalize the MySQL statements.
It's irritating to me to only be able to auto complete statements like
'SELECT', 'ALTER', & 'INSERT' only if I hold d
I have a database called 'gaming' and with in that database there are
several tables and data. I was asked to find a module called 'ako
ldap' and disable it (setting it from 1 to 0). My question is how in
MySQL do I search for a string if I don't even know what table to
search in? I know how to sea
Guys - I am no expert but I don't think this is a DNS or rDNS issue.
All resolution appears to be working fine. When my PC (tuna) attempts
to connect to the MySQL server via MySQL Workbench, it says "Failed to
Connect to MySQL at mysql.iamghost.com:3306 with user root
Host 'tuna.iamghost.com' is no
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrote:
> GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY
> PASSWORD 'password';
>
> *.* ie for all databases , if want on particular DB
>
> GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com'
> IDENTIFIED BY
I am trying to connect to MySQL server [192.168.0.100] from my PC
[10.1.10.222] using MySQL Workbench and when I test the connection, I
get the following error:
"Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server."
Can someone please tell me what I need to do so I can allow r
Is it normal behavior for MySQL command type ahead not to work unless
you have a database selected? I notice that using the tab 'type ahead'
has no response unless I use a specific database. Is this normal
behavior?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> Maybe phpmyadmin is a choice
No I am only allowed to have MySQL installed. No GUI for DBA. I am
sure there is a way to verify the privileges via CLI, I just can't
locate it on the site / documentation.
--
MySQL General Mailing List
For list archi
I would like to know how I can verify what privileges have been
granted to a specific user on MySQL. I don't remember if my user
'carlos' has specific privileges on 'mydb' database. I am sure I could
simply re-run the following command:
GRANT ALL PRIVILEGES ON mydb.* TO 'carlos'@'localhost'
->
I downloaded a MySQL script that backs up all my databases
automatically which looks to work amazing. My question is in this
particular script (linked below) there is a section to add a user name
and password for someone who has access to the databases I am
attempting to backup with the script. Now
I downloaded a MySQL backup script today since I have 3 or 4
relatively small databases. The script can be found here:
http://sourceforge.net/projects/automysqlbackup/
Now I was wondering if I can create a local database user
'backup'@'localhost' & grant him a level of permissions needed to
perfo
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman wrote:
> On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens
> wrote:
>>
>> hearing from many admins that MySQL expects and needs there to be
>> three accounts for root. Them being 'localhost', 127.0.0.1, and
>
Today I installed MySQL 5.1.45-1 on my production server and it
recommended that I run the following:
/usr/bin/mysql_secure_installation
When I ran this, it simply guided me to do the following:
- set root password
- disable remote login for root
- remove 'anonymous' user accounts
- delete 'test
On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey wrote:
> Please read the tutorial, let us know if you have questions on the
> information in it:
> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
Thank you very much for the link...
I did:
UPDATE sun SET serial = '0123456789' WHERE Model = 'Ul
I know this is very basic for most on the list but I need some MySQL
help. I am logged into my database and I successfully changed a 'field
type' from INT to VARCHAR. Now I need to modify the actual data I
inserted into those specific fields. I checked the manual and could
not really gather exactly
On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards
wrote:
> DELETE FROM mysql.user WHERE user='';
> FLUSH PRIVILEGES;
That worked and I thank you however I am wondering why the MySQL guide
was incorrect? Perhaps it's right but I did something wrong. Any
thoughts?
--
MySQL General Mailing List
Fo
I installed MySQL 5 today and started by setting up root passwords for
all three root accounts:
mysql> select User, Password, Host, Create_priv from user;
+--+---+---+-+
| User | Password | Host |
I am looking for a front end application that will allow me to enter
in all my server / workstation data into a MySQL backend running on
Linux. I have been told that I need to take all 75 servers we have in
our server room and keep a database of the following:
- Make
- Model
- O.S.
- I.P.
- Hostna
20 matches
Mail list logo
