Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).
View Complete Forum Thread with Replies
Related Forum Messages:
MySql Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a Windows 2000 machine.
View Replies !
Importing Tables Using MySQL Control Center
I am using Dreamweaver MX to create a data-driven web site. With the VPS hosting plan we're on, our remote FreeBSD server only supports the PHP application server. PHP requires MySql. Thus, I installed a copy of MySQL Control Center 0.9.2 beta. (I prefer a GUI and not command prompts unless necessary.) The information I plan on using in developing this site will be derived from a contact management program called GoldMine. The records will be exported into DBase tables, and somehow imported into the MySQL/PHP/Dreamweaver environment. From what I can gather so far, the MySQL environment I'm working under will not work with Access or DBase tables. Thus, I've created a new table in MySQL and re-created the various fields to match what I have in the DBase table. Now I want to import all the records I have in my DBase table. In fact, I will need to update the MySQL database weekly. So far, I have been successful in making all the connections work, except for importing the table into MySQL. In the MySQL Control Center, once you connect to the database, there is an option to import, but it is dimmed out. How do I make it work?
View Replies !
Control Center :: GUI To Connect To A Remote Mysql Database
I'm trying to get the GUI to connect to a remote mysql database from my client machine. What is the proper syntax for this in the GUI? I have tried everything with no luck: using the ip of the host, using the complete dns hostname of the host, using root as the user, using root@hostname as the user. I keep getting access denied for every attempt. I'm sure I am using the correct password.
View Replies !
Control Center
Getting the following message when I click on the MySQL shortcut on my desk top: Error Starting Program The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion numbers. A device attached to the system is not functioning. Have gotten both Dll's and stuck em in the system and program directory... nothing happening there. Would like to find out what "Rtlgetntversion numbers" is all about.
View Replies !
Control Center As A GUI
I started using Control Center as a GUI for MySQL. Making progress but I could do better if I had the help file. It is grayed out. Is there a place to locate this?
View Replies !
Control Center On MAC OS
I am running MAC OS X 10.5. I am learning PHP and bought build your own database driven website using php & mysql. In this book they tell me to download the mysql cc - but it is old and outdated and i can't get it to work properly.
View Replies !
Start Control Center
Getting the following message when I click on the MySQL shortcut on my desk top: Error Starting Program The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion numbers. A device attached to the system is not functioning. Have gotten both Dll's and stuck em in the system and program directory... nothing happening there. Would like to find out what "Rtlgetntversion numbers" is all about.
View Replies !
Control Center :: Stuck And Hangs
I am trying to install MySQL Control Center for the first time (the latest version). I am using Windows XP. When I try running the setup routine, I get through all the prompts and when it starts to install, it gets stuck at the 'Initializing... ' screen. And it does not go any further. I cannot even cancel. the operation.
View Replies !
Control Center Confusing Hosts
I've got control center installed on my localhost machine where I piddle around with db's on my machine. Today I attempted to connect to another server to assist others in their db work. I inserted xxx.xxx.x.xx for my IP address (obviously I'm susbstituting my actual IP) and when I selected "text", I was echoed back the string: ERROR 1045: Access denied for user: 'xxxx@ooo.ooo.o.ooo' (using password: YES) The complex issue is this, I inserted xxx.xxx.x.xx as my host IP, but instead of using my host IP to test the connection, control center used my localhost IP.
View Replies !
Control Center Showing Only 1000 Rows
I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a Windows 2000 machine.
View Replies !
ERROR 1045 When Testing In The Control Center
In the MySQL Control Center 0.9.4-beta, I right click the top level server name and choose the Edit option. Then I have entered a User Name and a Password in the General TAB. I then mark the option "Promt for Password" and hit the "Test" button. I get a small window where I should enter the password for User name@Host name. I enter the password and hit the OK button. Now I get the error message "ERROR 1045; Access denied for user; 'User name@Host name' (Using password: YES)" When looking in the Help menu, the Contents - F1 is not activated, so I can't get any online help. I'm just wondering why the test for the password failed and why there are no online help in the consol?
View Replies !
Control Center Connect Network/router
I can access my MySQL database with MySQL Control Center from a computer with a direct connection to the internet, but I can't do it from my other computer on a network. Is there a way to use MySQL Command Center through a network/router? I'm unable to find any connection settings options in the program.
View Replies !
Control Center "2013 - Lost Connection..." And ByteFX
I'm currently trying to move from MS SQLServer to MySQL, running onwindows XP. When trying to connect to mysql on localhost with mysql control center I get the 2013-error "Lost connection to MySQL server during query". I can connect from command line. If I do so, and change passwords by using OLD_PASSWORD('<password>'), control center runs nicely, but then ByteFX fails to connect with "Access denied for user...". If I set the passwords with PASSWORD('<password>'), ByteFX runs nicely, but Control Center fails.
View Replies !
What Has Replaced The "Control Center"
I used to work with the so called Control Center but that seem not work with the current version of MySQL. With the "Administrator" I don't find any functionality to enter data into tables. I really miss that functionality. Is there no other way than writing INSERT statements with SQL? What program can I use for that purpose?
View Replies !
How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL. The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally. 1. How to create a MySQL DB and Upload it? 2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally? 2. How to download and make backup?
View Replies !
MySQL Have No Permissions
I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting permissions correctly. Can anyone tell me which files and paths I should check (and change)? Ideally, I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
MySQL Permissions
I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
What Parameter Control Mysql-bin Logs Size?
ls -althr Unix file system listing of bin files. 1.1G Mar 27 08:53 mysql-bin.000010 1.1G Mar 27 19:48 mysql-bin.000011 1.1G Mar 28 01:28 mysql-bin.000012 I see ALL my mysql-bin logs are about 1.1Gb in size and there must be an parameter that tell them to switch when It reaches this value but I can not see which parameter that controls this in ‘show variables’ or my.ctf - I would suspect it was max_binlog_size but the value does not come close to 1.1.G – do ANYBODY know what tells them to be 1.1G in size? mysql> show variables like '%bin%' ; ....
View Replies !
Local Remote Command Control For Mysql?
ok, My website is hosted remotely onto my Web Hosting company. and i want to control MySQL remotely or locally in my computer without using PHPMyAdmin. I notice using PHPMyAdmin is very tiresome and also i'm thinking if there is a good alternative for PHPMyadmin so that i don't need to enter my CPANEL website everytime i do the work using PHPMyadmin. I'm thinking perhaps just like Microsoft Express/Outlook functionality instead of opening my Yahoo emaail account they will be sending the incoming and outgoing messages into my email automatically. This are the features that i'm looking for as an alternative for PHPMyAdmin.
View Replies !
Newb Starting MySql-Permissions
I have debian running and this is how I have it setup # ls -ld /var/lib/mysql drwxr-xr-x 4 mysql mysql 4096 Aug 19 11:29 /var/lib/mysql I was shown how to setup a password for user mysql here http://dle.ascendant.ca/restoring-mysql-root-HOWTO.txt, because at one time all I would have to do it hit enter after # mysql -h localhost -p -u mysql Enter password: (no password is added I just hit enter) Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 16 to server version: 4.0.14-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> ( can do whatever I want now???) If I type in the correct password it lets me in, if I type in no passowrd it lets me in, if I type in the INCORRECT password it does NOT let me in. How can I make it so that if no password is typed it still treats it as incorrect?
View Replies !
Creating Group Permissions In MySQL
I would like to be able to assign my employees to groups based on what department they are in (all users in accounting would belong to the accounting group, all users in customer service would belong to the customer service group). Then I want to be able to grant database permissions based on what group a user is in: something like GRANT SELECT TO myTable FOR AccountingGroup (obviously not ANSI SQL). Is there an easy way to do this?
View Replies !
User Permissions: MySQL DB Design
There is a huge problem I have been breaking my head over in the field of setting user permissions for my CMS. It is still in the development stage so I have all the freedom I need for any adjustments I need to make. My main focus of worry is on how to set the permissions, not in a static, but in a dynamic way. The end goal is to install the CMS for a variety of people. They will then have the control to make their own user groups and permission rules for each group and post. What I am having problems with is the following: Figuring out how to design the database to give me the options to: -Set read, write, edit, move, delete, vote, comment, attach permissions for posts. -Users can only do these things on posts of their user-level and lower or if they are the author. IF the post category allows this. Update: Where I am at now: I have decided to go with assigning 'levels' to each group and for each action. Level 0 is the admin level, the admin can do whatever he wants. Level 255 is a ban. I think I should set level-requirements on different types of posts. Let's say an admin announcement has edit-requirement level 0 where as an author article would have edit-requirement level 1 so only trusted mods can change it but reading-level 10 so all people can read it. (example level values). I was thinking something like this: posts[post_id....post_level_id=ì«'] post_permissions[permission_id=ì«', read_level=ཆ' edit_level=Ƈ' delete_level=Ɔ'....etc] Do you guys think this would be a good way to go? And how would you integrate this into the database? As stated before I edited the post a bit.
View Replies !
Unable To Connect To Mysql With Root Permissions
I am trying to connect to a new mysql installation. I have given root permission to connect to all databases from anywhere; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION; I can log on locally by specifying the host name: [me@au101 me]$ mysql -h 127.0.0.1 -u root -p test Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 to server version: 5.0.18-standard However, when I try to log in locally without specifying the host name I receive the following error: [me@au101 me]$ mysql -u root -p mysql Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) If I try to connect remotely as root using MySQLyog I receive a similar error message: Access denied for user root@[my ip
View Replies !
Control Centre 0.8.10
I'm running mySQL V4.1 on XP Pro. I'm also using mySQL Control Centre 0.8.10 beta. I can shut a server down, but there's no UI (that I can find) to start it again. If I go run services.msc I can't get mySQL to stop, or restart as it times out.
View Replies !
Control Max Time
Does anyone know of any parameters that can be set to control the maximum time limit mysql will allow a single query to run before timing out etc? Rather than let badly written queries run for long periods I would like to just abort them if they exceed a set amount of time. I know the php calling script should/could handle this with defensive coding etc. However, I'm not always in control of how other users write their scripts that interact with mysql.
View Replies !
Control Panel
i'm having some problems with my MySQL install. Firstlty when I installed MySQL I never got an icon of any kind within the control panel. I've been looking at tutorials of how to create a database and many of them use the control panel option as a starting point but I can't because MySQL is not present within the cPanel. Also when I click on the MySQLadmin.exe in the bin it does not open probably. It opens briefly- shows a black screen with decending text. It then dissappears completely after several seconds. It cannot be seen or opened in the tray
View Replies !
Transaction Control
I am a recent user in mysql and I'd like to know if I need control the transactions in java when I am using mysql. I am asking it because I have read the mysql already control the transactions automatically, that is, it automatically control the commit and roolback commands.
View Replies !
Flow Control
I worked with MSSQL, where I could easily do things like inserting a new record into a teble if the table is empty and updating an existing record otherwise. Is it possible in MySQL, and how? From what I have read about the IF operator, it does nothing but choose which result to return. But I need a branching operator that would choose which piece of code (SQL Script) to execute.
View Replies !
Remote Control
I have MySQL running on a desktop computer that I log into through logmein.com and this is not the best solution. How can I connect remotely to use the MySQL Command Line Client on my desktop so I don't have to wait so long for each line to appear? I should also point out that this computer is on my LAN, so I shouldn't have to configure the router. One problem I am running into right now is that when I try to make a new table, I keep getting error 1064 (42000) and I'm not sure why because everything looks correct. Code:
View Replies !
Revision Control
I've been searching the mysql forums and documentation for anwers to this to no avail..Is there any facility for revision control within mysql? I need to be able to have snapshots of a mysql database that users can modify, later merging those modifications in with the main database, similar to branching in cvs. Does something like this exist already? Is it doable by copying the database and then logging edit transactions on the copy? What about using the storage engine plugin for tracking modifications?
View Replies !
Control Flow
I am having a hard time with Control Flows which is what i think I need to solve my current problem. Below is a sample query dynamically built based on user screen selections. Notice that it attempts to JOIN 5 tables to fscenario. My problem is that fscenario.`fsce_comp` may or may not be NULL. Either way I need the record retrieved if all other criteria is met. If fscenario.`fsce_comp` is not NULL I want to display the corresponding fcomponent.`fcom_name`. If fscenario.`fsce_comp` is NULL, I still want to retrieve the record displaying nothing for the name. Bad explanation, so I hope you follow? Using the manual (http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html) I have tried several IF, CASE, IFNULL structures. They all return records where fscenario.`fsce_comp` is populated and exclude the records where fscenario.`fsce_comp` is NULL. I guess I am not understanding how to implement the syntax......
View Replies !
Control Flow Functions Using IF
In my table entries I have three columns - entid, userid and service and each time a user uses a service a new entry in the table is created. So the table could look something like this: Code: entid userid service 1 12 auto 2 12 comp 3 45 lubid 4 12 comp 5 67 vote I want to create an SQL statement that lets me select all the users that have entered the service comp >=1 times, and auto >=1 times. So with the above data only userid 12 should be returned. At present I have the SQL: Code: SELECT userid, count(service) as servicecount WHERE entid > 0 GROUP BY userid,service Then in a while loop I only select the userid's that have a count of comp >=1 and auto >=1. This takes a long time on big sets of data. Is there a way I can do this all in the SQL? I was looking into Code: COUNT(IF(service>1,1,NULL)) However can't specify which service this is....
View Replies !
Hosts Control Panel
I am using my hosts control panel to run a mysql sql statement to create a stored procedure. CREATE PROCEDURE usp_testerproc1() BEGIN SELECT * FROM tbl_users; END It returns the following 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 'PROCEDURE usp_testerproc1() BEGIN SELECT * FROM tbl_users' at NOTE: I am writing this test sql due to the upload of my mysql.sql file failing on DROP PROCEDURE IF EXISTS 'usp_getusers'; It gave me pretty much the same error as above. The hosts are using mysql 4.x on their servers.
View Replies !
Control Query Parameters
save myself a lot of php by do something like as follows: if form values are a > 1 and b =1, then do the mysql query using 'a' value else if form values are a = 1 and b > 1, then do the mysql query using 'b' value else if form values are a=1 and b =1, then return value: " try again". Below, slightly more fully roughed out. If $_GET['keyword1']>1 & $_GET['keyword2=1'], do query "select * from content where '$_GET['keyword1']' = something " elseif $_GET['keyword1']=1 & $_GET['keyword2>1'], do query "select * from content where '$_GET['keyword2']' = somethingelse " elseif $_GET['keyword1']=1 & $_GET['keyword2=1'], return value " try again" Can this be done via mysql rather than rubbishing around w PHP, wh I like to keep to an absolute minimum.
View Replies !
Permissions On Mac
I used MAMP to set up MySQL and Apache on my Mac and installed Drupal. Everything was working fine but I thought that I had forgotten to change the password for the 'root' user in mysql. So,with MAMP when you go to "localhost:8888 it gives you a start page where you can access mysqladmin and others. I used mysqladmin to change the root user properties but now when I try to launch the start page I get "could not connect with mysql server" Any idea how I can get to MySQL another way and fix it without having to reinstall? My Drupal installation still works so I know MySQL is working but I can't get to the admin/start page anymore. Also, I'm a complete newb at this stuff.. I know I can go to a terminal session on my Mac to access mysql directly but I don't know enough about it to do anything.
View Replies !
Solution For 'repetition Control' (slideshow App. For Web)
Im currently developing a web portal wich will serve, as part, as a customizable slideshow presentation. The user will have the option to select multiple galleries of images of different subjects, each gallery containing several images. The slideshow's 'playlist' function plays a certain number of images from one gallery then moves on to the next on. I.e., the playlist have 200 galleries, and will display 5 images per gallery. Its imperative to the system to have a 'image repetition free environment', to assure that, when a gallery that was previously displayed shows up again in the playlist, the next 5 images of that gallery wont be the same as the ones previously played. Code:
View Replies !
Could Not Connect To The Service Control Manager
I'm trying to run MySQL Server 4.1 on Windows Vista Beta 2. I was able to install the server before. But when I uninstalled and tried reinstalling, I got the following message at the end of the Instance Configuration Wizard: Could not connect to the Service Control Manager I got this message once before when I first tried to install MySQL on Vista Beta 1. Can anyone help me diagnose the problem?
View Replies !
Any Db Design Of FIFO For Inventory Control
I am asked to do a job that's creating fifo (first in first out) for inventory control. There are many kinds of transaction such as: Goods purchasing, Return Goods Purchased, Moving Goods from one warehouse to another one, change the goods name (like from fresh tomatoes to rotten tomatoes), Selling (Invoice) and Credit Invoice (Return for Sales). I was so confused and I did a table like this: ...
View Replies !
Default Permissions
This is a fairly simple question but I'm new to mySQL. To log on to mySQL I need to type at the prompt: mysql --user='username' --password='password' as opposed to just typing mysql and being recognized without having to type identification. Anyone know how I can change this?
View Replies !
Database Permissions
I've got databases on one box i have to transfer to another box, both are running Linux one a Centos4 machine, the other rh9 i think. I could tar up the /var/lib/mysql directory, but i was lead to believe that was a bad idea. I don't know the permissions of the user's and i don't want to give out global permissions. What i was wondering is there a way i can do a mysqldump on the databases on machine1, which will drop everything needed to recreate them in to a .sql file, transfer that to machine2 and then use mysqladmin to load it and have all the settings back in business? I believe they're both mysql4 installs, though machine1 might be mysql3.23, not sure.
View Replies !
Permissions Change
Running MySQL 4.0.18 (upgraded from MySQL 3.x), I can set the host for a user to "%", and can connect from localhost just fine, as well as remote locations.On another server running 4.0.21 (clean install), if I set the host to "%", I cannot connect from localhost unless I also set a "localhost" entry as well for that user.
View Replies !
Permissions With New Db's
I've got php script that created a database, then the tables in the database. The user in which the script is run, doesn't have the permissions to create a 'new' db. Moreover, mysql says that because the user is trying to create a new db, and there isn't a row specifying that the use has permission, doesn't allow the user to create the db. My solution is that I can create a row in the mysql.db table that will allow for the user to have proper permissions. My problem is that once I insert that row, it takes another post to the page for the permission to actually take hold. Is there a way to have the permissions take hold sooner? Some of the things I have tried would be toRedirect the page to (with a php header call) to re-load the pageClose the mysql connection so that a new one would have to be opened
View Replies !
|
TRACKER
