Accessing All Databases
I have a problem everybody who has a username and password can access to all databases even mysql database (the one which user details are in it) and able to delete or edit any data.
I thought mysql is on skip grant tables mode but I did reload or flush-privileges nothing changes.I manualy go there any set all privileges to that user N but that user still able to access only mysql database and this is very dangerous because they can edit or delete any user. I tried to delete user and any user can delete any user yes.
In that case I need your help what command I need to write to fix this problem.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Accessing Dev.mysql.com
I'm trying to download MySQL4.1 from the MySQL site and when I try and go to the download section on the site it either fails or, if it loads, the "pick a mirror site" links always fail. By "fail" I mean that it doesn't manage to retrieve the requested page, either sticking on "waiting for dev.mysql.com" or "connecting to dev.mysql.com" in the status line of the browser, eventually giving up with an "operation timed out" error message. Is anyone else having this problem or is it just me? - this has been ongoing for the past couple of days now. Incidentally, I need a version of MySQL that can handle subqueries yet I'm still using glibc-2.2.5-40 and Redhat 7.3 (upgrading simply isn't an option right now) - can anyone suggest a stable sub-version of 4.1 that fits this criteria?
View Replies !
View Related
Accessing Data With In It
I have a problem selecting records with in any values. For example: SELECT * FROM ADDRESS WHERE STREET = "A" will give an error: If I replace with then it works. Eg. SELECT * FROM ADDRESS WHERE STREET = "A" Is there any setting in MySQL that can overcome this?
View Replies !
View Related
Accessing DBMS
Some of our customers have remote offices. I was wondering if it'd be safe to have a DBMS running at their central office, and have our client application running on hosts in the branches connect to it through a VPN via the Net? What happens if the connection goes south while a branch office was making changes? Does the DBMS just rollbacks changes automatically after a time-out? Should we set up some kind of replication instead? Also, are there compeling reasons to go for Firebird instead of MySQL? I don't know enough about the capabilities of each DBMS today to make an educated choice.
View Replies !
View Related
Accessing Phpmyadmin
ive been trying to figure this out for a while and heres my problem...I go to security and change my password, and then i go to config.inc.php file and change my controlluser and user to root well its like that already, but then i change my passwords to match... and it still wont let me in. please someone help. And am i suppose to change both controll user and controllpassword .and user and pasword?
View Replies !
View Related
Accessing Tables
I am writing a php ui for admin of Jabber2 user information. Looks like most user info is stored in a MySQL db. However the table names have some '-' in them. For example, I am trying to run the following command: desc roster-groups; and I get: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-groups' at line 1
View Replies !
View Related
Database Accessing
I am created a database in one pc and i copied the database to another pc.when i try to execute on any tables in that database i am getting a error that table doesn't exists.how to solve this problem?
View Replies !
View Related
Accessing MS-SQL Server
I need to integrate some data of a system that uses MySQL 5.0 with one system that uses MS-SQL Serve Express Edition. How can I do this? Is it possible call a SP in the SQL Server database from a SP/Trigger in the MySQL database?
View Replies !
View Related
ACCESSING A FILE
I have installed MySQL version 5.0.41-community-nt on my machine using a windows installer. The tut was done using version 4.1. I was able to follow everything in it up until the last two steps of the tut. I was trying to create a table called "createnamestable.sql" within the "test" database by creating it in notepad, pasting the following code in it: CREATE TABLE Names ( ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FirstName TINYTEXT NOT NULL, LastName TINYTEXT NOT NULL ); Then place it in any folder and then try to open it with the following syntax: C:Program FilesMySQLMySQL Server 5.0data estcreatenamestable.sql; To my surprise it did not work. I thought that putting the "createnamestable.sql" file in the same folder as the "test" database would help but it didn't The errors I get are: Error: Unknown command 'D' . Error: Unknown command 'M' Error: Unknown command 'M' I don't know what else to do. is the syntax that I used wrong for my version of MySQL? I would really be grateful if someone can help me out with this.
View Replies !
View Related
Accessing A Table
I've been using a simple table within a database for a year or so now without any problems. It has an index called 'id' (int(11)) which increments every time a new record is added, 10 columns of various types and probably around 3 million records. Recently this table has stopped responding. I can: describe the table see the table using 'show tables' perform all normal operations on all other tables in the database I can't: update the table check the table (I think - it has been running for an hour with no response) select any data from the table, even something simple like max(id) Does anyone know what the problem could be?
View Replies !
View Related
Accessing Auto_Increment Value
How to get current auto_increment value for some table? LAST_INSERT_ID doesn't help if we do not perform any inserts before and it returns 0. For example, if table is empty, but it's auto_increment value is X how can I get X?
View Replies !
View Related
Accessing A Databse
I am new to programming, I am working on HTML forms in which i am using checkboxes now, when the user clicks on the checkbox, then i have to call a function which does some math for which i have to access the database. For which i thought i will use PHP. Can i use onclick event in PHP or I wonder if i can access a database through Javascript.
View Replies !
View Related
Accessing Remote DB
i want to inser data into a remote dB. I cant for the life of me get it to connect. The mysql_connect syntax is straightforward. Ive tried the ip number and domain name, the user name and pass are correct. No firewall probs. Always an error lilke this: "Can't connect to MySQL server on '130.220.33.14' (10054)" I use phpdev to run the files at home. Is there maybe a config I have to change on it to access remotely?
View Replies !
View Related
Accessing A Table Line
I have a table in my databasee called tablebob. tablebob has three fields (idnumber, address, other). the table is organized by the idnumber. The problem is I don't know the idnumber. Please Note: because of responce time problems, I can NOT have the php page search through the entire table, and check the contents of each row one by one. I need to submit a quary saying something to the affect of "select from tablebob a row where address = www.google.com"
View Replies !
View Related
Accessing MySQL DB From Another Domain
what is the best way to access data in a MySQL database on one domain from a PHP script on another. We have a secure (SSL) server on one domain which will be used for secure credit card transactions. We would like to be able to extract insecure contact information from MySQL database on another domain in another hosting environment.
View Replies !
View Related
Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against MS SQL on a corporate network. I have a Yahoo web page, and I'm going to use their MySQL DB. I want to run queries, Inserts, Updates and Deletes. I have no idea how to connect to MySql on Yahoo from a client like C# or VFP.
View Replies !
View Related
Accessing MySQL Database.
I have recently installed MySQL 5.0.27 / PHP 5.2.0 / Apache 2.2.3 on an XP os. I created an empty database via the MySQL command line which is visible when I type SHOW DATABASES at the mysql prompt. I have changed my root password which works OK. I set up the password to the empty db by: GRANT ALL ON database name.* TO username@localhost IDENTIFIED BY 'password' To access the db, when I type : mysql -D dbname -u username -p I do not get a prompt to enter the password.
View Replies !
View Related
Accessing A Backup From Another Machine
Have downloaded a mysql backup from another machine and used phpMyAdmin to restore the DB. It works fine and I can see / manipulate the data fine using phpMyAdmin, BUT when I try to access via the application it generates the following --> SQL ERROR [ mysql4 ] Access denied for user 'mossfarm_mossy'@'localhost' (using password: YES) [1045] An sql error occurred while fetching this page. --- mossfarm is the name of the mySQL login on the original machine... Since this is my db I know all the passwords etc, but do not understand the issue this is telling me about... Do I need to set up a new user in MySQL or what. If so, using the above who would it be?
View Replies !
View Related
Accessing Existing DB From Files Off A CD
I inherited a project from another developer who was fired. There is no database documentation. There is both an SQL backup file and the original database files on a CD. I have recreated the db from the backup file and that worked perfectly. However, I don't have full confidence in the accuracy of the backup file. I was wondering if I can somehow access the db from the files on the CD. I copied the files to a folder on my machine and then changed the MySQL data folder setting to that folder. Unfortunately MySQL wouldn't start. What would I need to do to be able to have MySQL use the files copied from the CD as the data files?
View Replies !
View Related
Accessing Mysql From Another Host
New install of mysql on Solaris 10 x86. I cannot connect from any other host, lots of traffic on google with people with the same error. Talk of the grant command fixing this, but no details. So simple question. What "exactly" do I type to allow connections to port 3306 from another host to avoid messages such as ERROR 1130 (00000): Host 'am-ms-t.foo.baa' is not allowed to connect to this MySQL server
View Replies !
View Related
Accessing MySQL Data
This morning when I tried to access my MySQL installation through MySQL Query Browser, all schemas have a message stating "Fecthing Data..." when I expand the schema. If I access MySQL through the command line, I get the following message when I execute a "use" command: "Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A" If I execute mysql using "-A", then it appears I can access the data, but it's very slow. Has anyone experienced this and if so, do you know how to resolve it?
View Replies !
View Related
Accessing Mysql Server On LAN
I have a problem accessing mysql server on my LAN: i can access it locally but not from other machine. The error is: Lost connection to mysql server during query. I've disabled the firewall but it's still not working. What i don't know is if i set the users correctly...
View Replies !
View Related
Accessing A Mysql DB Remotely
I am building a kiosk which uses a lockdown browser. The browser uses a php page to access a MySQL DB on a web server. It will not allow me to connect to the DB because I am using the following connection string: mysql_connect("localhost","*****","*****"); mysql_select_db("******") or die ('I cannot connect to the database because: ' . mysql_error()); I know that the problem here is that I'm trying to connect to 'localhost' when the actual DB resides elsewhere. The question I'm asking is how to find out how to connect to my DB. Is it just mysql.mydomain.com instead of localhost or what?
View Replies !
View Related
Accessing Only Part Of A Database Value
I'm currently writing a form where a user will input the first three characters of a postcode. In my database I have registered users full postcodes, but when I run my query I only want to match the from the form to the first three letters of the database value.
View Replies !
View Related
Error 1130 When Accessing MySQL From Another IP??
I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the following error: MySQL Error Number 1130 #HY000Host '192.168.0.5' is not allowed to this MySQL server Ping works fine. On searching the internet, I find reference to "allow list" hidden somewhere in the guts of MySQL. Can anyone provide me hints on how to add to this list?
View Replies !
View Related
Accessing A BMP Image From A Binary Field In The DB
Now I would like to now if there is a function that does the opposite to LOAD_FILE? I have tried using SQLFetch after using a SQLBindCol, but all I get returned is the first 4 bytes even if the size of the buffer I use is 1024 bytes big and this size has been passed as a parameter to the SQLBindCol function. I am using the ODBC API of Microsoft Visual Studio 6 and MyODBC Driver version 3.51. The MySQL version is 4.0.12-nt.
View Replies !
View Related
Accessing Mysql After Fresh Installation
I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message " Access denied for user root@local host .......using password yes" i have tried all the options like #mysql -u root -h localhost #mysql -u root -h localhost -p #mysql -u root -h localhost -p mysql #mysql -u root -h localhost test -p #mysql -u root -h localhost test #mysql -u root #mysql -u root mysql but none of the option is working at all. Please any idea how i can change the root password or enter the mysql after fresh installation.
View Replies !
View Related
Error Accessing MS Access Table
In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each datasource. I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked.
View Replies !
View Related
Accessing Mysql Database From Php File
I can access mysql in dos with the command of c:mysqlinmysql -u root mysql but when i write the command of mysql_connect ("localhost", "username", "password") i don't know what my username or password is. I have installed Apache to run the mysql database and php on my computer although I don't know where to find out the username and password so if someone could help that would be great.
View Replies !
View Related
Accessing Remote Data Folder
I have MySql 4.0.17 server on my machine. My data folder is on a network drive. Recently I installed MySql 4.0.17 on a different machine, changed the my.ini file to point to the same remote data folder and restarted the MySql. I get the following error- "Could not start the MySql Server on local computer. Error 1067: The process terminated unexpectedly". So I copied the remote data folder onto my local machine and changed the my.ini accordingly, it is working perfectly fine. The storage engine is Innodb. Am I missing something here. I am pasting the contents of my my.ini file below. Code:
View Replies !
View Related
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
View Replies !
View Related
Trouble With Accessing Database -- Too Many Rows?
The database is used for an online game. One of the tables keeps track of all the lands in the game. There are 7 continents, each with a different set number of regions (239 in total). Each region has 625 sectors, and each sector contains 25 lands. The total number of rows in the database is 3,734,375. I recently populated the table with the necessary rows. The table comes out to over 93MB. I've already modified the structure of the table to maximize the space usage. I had no problems accesses my database before populating the world. However, now that I have, I can't access the database as a whole. I can send queries to select certain tables (such as the user table), and even check out the individual table structures in phpMyAdmin. But it locks up every time I try to connect to the database directly (ie selecting the database using phpMyAdmin or connecting through the game). I suspect it's because of the huge amount of data in the database. I tried to send a query to delete all the records in the land table, but it doesn't go through and just locks up.
View Replies !
View Related
Accessing Remote MySQL Database
Is it possible to access remote MySQL databases? I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.
View Replies !
View Related
Accessing Data On An SQL-Server By Using MySQL-Select
is it possible to access data located in a SQL-Server-Database by using a MySQL SELECT-Statement? I know that on an I can use a qurey like the following SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:Financeaccount.xls";User ID=Admin;Password=;Extended properties=Excel 5.0') on an MS-SQL-Server and search for something similar in MySQL.
View Replies !
View Related
Accessing A Mysql Database On A Remote Server
i would like to know how to connect to a remote mysql server which is on linux from a windows system. I gave the command: mysql -u root -p redhat -h 192.168.1.132, where the ip is the ip of the linux server. But i got the error message stating that :- Host 192.168.1.114(which is my system ip) is not allowed to connect to this MySQL server.Sreejith
View Replies !
View Related
|
TRACKER
