Dont Start If The User Dont Have Administrator Privileges On The PC
I instaled MySQL in a computer (with widows XP) that not always is loged with a user withthe computer administrator privileges.
when a person whitout administrator privileges is the first person that
logs, the DataBase dont startup until an administrator logs on. What can i do to allways startup the DB without care the computer's administrator privileges?
View Complete Forum Thread with Replies
Related Forum Messages:
Dont Have An Error File
I have problems setting up the server. When trying to start it it gives me Error 0 and when I look for my error logfile in the data directory I don't find one. In the manual it is written that it should be there unless you tell the server to put it somewhere else but I didn't do this.
View Replies !
All Entries Which 'dont' Match
I am trying to query a list of hosts and extract all entries which 'dont' match. SELECT LOGS.host, GOODLIST.host FROM LOGS,db.GOODLIST WHERE (LOGS.host <> GOODLIST.host) When I use this query, it is very very slow. Matching the host with the GOODLIST.host works great and fast but when I use <> to get the hosts which DONT match, it doesnt work as expected.
View Replies !
How Do I Make It Dynamic I Dont Want 20 000 Pages Of Data?
I havent really got a clue what im doing so i need some help I am tryig to create a site with news on it the problem im having is that on my index.php isbring up the headlines with a section of content $leader fine but how do i create a link from the $headline to the same page (dynamic) but only showing the headline and full content of the headline clicked on. I cant get my pages to be dynamic which is the whole idea of using mysql and php so please teach me or send me to some decent tutorials the manual on php.net is to technical it doesnt explain anything and the other tutorials out there are to simple they dont get into the complex stuff. here is the code <? include("inf.php"); mysql_connect($hostname,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM ($tablename)"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $id=mysql_result($result,$i,"id"); $datetime=mysql_result($result,$i,"datetime"); $subject=mysql_result($result,$i,"subject"); $headline=mysql_result($result,$i,"headline"); $leader=mysql_result($result,$i,"leader"); $content=mysql_result($result,$i,"content"); ?> <!-- Begin #main --> <div id="main"> <div id="main2"> <div id="main3"> <h2 class="date-header"> <? include("site/includes/time.php"); ?> </h2> <div class="post"> <h3 class="post-title"> <!-- On the main index.php page I want 5 headlines and then I want the headline to link to this same (dynamic) page but with the variable $content also showing and the other four headlines no longer showing --> <a href="Article alone page" title="permanent link"><? echo "$headline"; ?> </a> - posted on <? echo "$datetime"; ?></h3> <div class="post-body"> <p> <b><? echo "$leader"; ?></b> </p> </div> </div> <div class="post"> <div> <br /> </div> </div> </div></div></div> <!-- End #main --> <? ++$i; } ?>
View Replies !
Dont Display Record After Date Has Passed
Lets say I am making a site that has upcoming birthdays of a whole lot of people, and I want to display only the birthdays that have not happened yet (ie where birthday > current date). What I do not know, is what format I must enter the date into; at the moment I am just using a char type in my MySQL database and entering it as : 26/03 (or what ever). Also, how would I get the current date and compare it to this date?
View Replies !
Mysql Client Dont Write Russian Characters
I installed MySQL 5.0.24 and have so problem.I can't type russian characters in mysql client. Database has data in koi8 encoding (from dump, from php form...) and this data correctly shown.But when I switch encoding to russian in mysql client cursor stops moving independent from my keys pressing,when switch it return to English and typing continued.For example,I enter: select fld from tbl where fld="russ",if "russ" in koi8 I cann't type this characters. It is possible type russian characters from OS command line: mysql -p -e "select fld from tbl where fld='russ'" dbname. In this case whole query text will be entered and correctly executed. If anybody know how possibly decide this problem write me please. My OS is ALTLINUX 3.0 : LANG=ru_RU.KOI8-R MySQL's variables: | character_set_client | koi8r | character_set_connection | koi8r | character_set_database | koi8r | character_set_filesystem | binary | character_set_results | koi8r | character_set_server | koi8r | character_set_system | utf8 | character_sets_dir | /usr/local/mysql-standard-5.0.24-linux-i686/share/mysql/charsets/ | | collation_connection | koi8r_general_ci | collation_database | koi8r_general_ci | collation_server | koi8r_general_ci
View Replies !
Foreign Key Constraints Dont Work (suse Linux, Innodb)
i changed standard storage engine to innoDB and created tables to test the foreign key constraints: create table prof ( id integer auto_increment, name varchar(30) not null, primary key(id) ); and create table lesson ( id integer auto_increment, profid integer, name varchar(30), primary key(id), foreign key(profid) references prof(id) on delete cascade); now, when i delete a dataset in "lesson", it should delete the corresponding dataset in "prof" right? also, i shouldnt be able to create a dataset in "lesson", when there is no prof with the provided id i think. but it doesn't get deleted, and i also can create lessons with any profid, even if the prof with that id doesnt exists.. somehow the foreign key constraints dont work
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
Delete Rows From Table A, Which Dont Exist In Table B (base On Column X)
I have 2 tables identically structured. A & B Table A, has column: Product (product code) as primary key Table B doesn't. Apart from that they have the exact same fields. There's also a column: supplier I want to Delete * from table A, where does not exist in B (based on column: Product) & where supplier = apples So to elaborate. Table A is my main table, but it now contains outdated products from supplier apple. Table B has the latest list of products from supplier apple. So I want to remove old products from A that supplier apple no longer makes. mysql version 4.0.27
View Replies !
Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables in different databases. Now I have to create serveral more users with the same permission. Is there a command in MySQL that allows me to create the new user by copying the privileges from a template user?
View Replies !
A User Dba Privileges
I need to give a special user admin rights to the databases he creates. As there is no dedicated MySQL database server for his needs yet, we created a special user on a multi-purpose MySQL server; this special user has the rights to do everything only on databases he creates. To distinguish his databases among others, we require his databases' names to be prefixed by "PNCC_". Here's how we did the trick: Once logged in as DBA: mysql> GRANT ALL ON PNCC_.* TO fred@my.fqdn.com IDENTIFIED BY 'some_password' WITH GRANT OPTION; (The query ran OK) mysql> UPDATE db SET Db='PNCC_%' WHERE db='PNCC_'; (The query ran OK) (We had to do two different commands, as GRANT does not seem to accept wildcards). From now on, after having flushed privileges, user fred@my.fqdn.com can create databases with names prefixed by "PNCC_", create tables within these databases, and populates them. But this user would like to have the possibility to create users with special privileges on the databases/tables he previously created. The question is: how can I grant fred to create users with rights ONLY on PNCC_<some name> databases, and nothing else (ie. no access to other databases, nor on mysql.*)? Do I need to insert a special row within mysql.user? If so, which one?
View Replies !
User Privileges?
I'm in the root user account. Lets just say I have three databases called "database1","database2","database3". I also have three users called "user1","user2","user3". Now what I'm trying to do is to only allow user1 to acces database1. So when they login all they see is their database. I want them to add tables and do everything along those lines, but I don't want them to see other databases or create databases themsevles. I can't seem to get this right. How do I go about this? I am using phpMyAdmin version 2.6.1.
View Replies !
How To Set User Privileges
How do I need to set Privileges so that a user can create and modify their own databases? I am running MySQL 3.23.53 with phpMyAdmin 2.5.4. I have multiple DBs and users. I setup up a new user and database with no problem. The user can only see the new database as it should be. I would like to allow the user to be able to create their own databases. Right now in phpmyadmin, when they create a new database, they cannot create tables in it, and they can not see the database they just created in their list of databases. Although I can see the database they created with my admin user. When the user First creates a database and tries to create a table they get "select command denied to user". I gave the user global select, but as soon as I do they can see all the databases. I was guessing this is just a Privilege issue, but I am still learning about SQL privileges.
View Replies !
Changed User Privileges And Now I Can't Log In
I read several web sites and O'Reilly's book on MySQL about securing the system tables. I removed several users and, as advised inthe book and web sites, changed the user "root" to another name with another password. I removed the site name as a host but kept the IP address. Now when I use phpMySdmin to get back in, it let's me past the login popup BUT it gives me the message: Error MySQL said: Access denied for user: 'root@localhost' (Using password: YES) The data in the database is not important but the database structure/definition is. I'd like to find a way to back up or dump that. Then I can reload MySQL and start over.
View Replies !
How To Export User Privileges
I am working with MySQL 5.0 and phpMyAdmin. I know how to export (dump) the tables and data of the database with phpMyAdmin, but I couldn't find a way to do the same for the user accounts and their privileges.
View Replies !
New User [MySQL Administrator]
I'm getting an error when adding a new user: After I've entered MySQL User: XXX-WEB, Password and Confirm Password, I click Apply Changes a message box shows MySQL Administrator Exception: Error while storing the user informaiton. The user might have been deleted. Please refresh the user. I've refreshed, sooo many times... I think I may have messed up the MySQL schema and may have damaged some locks.
View Replies !
No Privileges For Root User
There is no privilege for root @ % for create user, create view, procedures etc. I tried to edit the user table directly. But it doesnt work. Please help to find a solution.
View Replies !
MySQL User / Privileges
1. Does it cause problems if there are multiple users with the same user name? 2. If 'localhost' is specified for the user host, does this mean that they can only gain access if they are logging in from the same host address where mysql is running?
View Replies !
Assigning User Privileges Error
I created a user 'cody' % and localhost and try to assign privileges to his database 'cal_cody' For some reason it don't work, posting this weird thing in forums didn't help either. so I tried: mysql> GRANT ALL PRIVILEGES ON cal_cody.* TO 'cody'@% IDENTIFIED BY 'access'; Query OK, 0 rows affected (0.00 sec) also tried: mysql> GRANT USAGE ON cal_cody.* TO 'cody'@'%' IDENTIFIED BY 'access' Query OK, 0 rows affected (0.00 sec) then tried the same for 'localhost' then even flashed the privileges and even reloaded the mysql service doesn't do jack Is there something wrong with my command, or is there a way to do this through phpmyadmin?
View Replies !
User Privileges In Version 4.1.7(linux)
sql: GRANT USAGE ON *.* TO 'shinestb'@'localhost' IDENTIFIED BY 'shinestb'; FLUSH PRIVIELGES; an error return at login time: ./mysql -ushinestb -p ERROR 1045 (28000): Access denied for user 'shinestb'@'localhost' (using password: NO why? version < 4.1 is ok.
View Replies !
Create User With Full Privileges As Root
I am trying to create a user with full privileges in addition to the root account, without that user being able to modifiy or even see root's databases. (My goal is to have a user that can create and edit databases, but without being able to access roots stuff). Does anyone know how to do this? And while on the topic of users, when doing a grant to username, is it possible to see if the username already exists and to stop the overwrite of that users priveleges?
View Replies !
How To Grant 'create Database' Privileges To A User
I created a user and wanted to allow he to create a database, how to grant the 'create' database privielege to he. > create user joe identified by '123456'; > use mysql; > update user set Create_priv='Y' where user='joe'; I know I can update the user table,but I'd like to know if these is dedicated statement for this purpose
View Replies !
User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine. mysql-administrator v1.0.22 is installed on RH Linux FC3 from the mysql-administrator-1.0.22a-1.rh9.i386.rpm. Everything seems to run fine except User Administration is *extremely* slow. If I click on "User Administration" in the sidebar, it takes about 2 minutes (seems like forever) before the window comes back with the infomation. All the other functions seem to function fine. Is it because I'm using mysql-administrator on a remote host? Do I need to move and rebuild the server to a newer Linux version? mysqlcc doesn't have this problem at all. (It's using the libraries from MySQL 4.1 that the databases were migrated to.)
View Replies !
Error In MySQL Administrator When I Try To Change The User Information
I recently install the MySQL 4.1.8-nt-max, and the MySQL Administrator, but when i try to change the information (name, description, email, etc.) in the Administrator I get the following error: " Invalid UTF-8 Error executing query (illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation '=' " Before it happens the Administrator crash down ... Im from Mexico, so my Windows XP regional configurations are spanish / latinamerican. Any ideas about it?
View Replies !
Login As Root User, And Grant Create Database Privileges
I am new, and I have been trying to find info on this unsuccessfully. Ok, so I am using Unix Terminal from my Mac. From the command prompt, I use Shell>/usr/local/mysql/bin/mysql to log in to the localhost user. Now, from the command prompt, i have tried using ,mysql -u root, and it says command not found!
View Replies !
Error 1142 - Mes. The Following Occured: SELECT Command Denied To User Xx@hostx.com For Table 'user
When trying to do anything to do with "User Administration" in MySQL Administrator 5.1 connecting to a remote MySQL database, I get the following message when I click on the "User Administration" icon/text in top left frame. Verbatim quote apart from my connection details which I am anonymising): A MySQL error was encountered. The message is: Could not fetch user names. The following occured: SELECT command denied to user xxx@hostxxx.xxx.xxx.com for table 'user' (1142) No I have looked through search and found the following: http://lists.mysql.com/mysql/134369 Unfortunately that tells me that it has happened to someone else but that's about it. What is one supposed to do with the fix? I am wondering if this is why I cannot create ordrop any tables with this username at the moment, even though it is the Admin level username....
View Replies !
Own Privileges
Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some = table? I'm using PHP4.
View Replies !
No Privileges
I have installed PHP and MYSQL as a testing server on my local machine using xampp. I then copied over the SQL data folders from my old machine. When I go into PHPMYADMIN the only database I can see is the informationschema and under create new database it states that I have no privelidges.
View Replies !
Using The My Sql Administrator
I hope this posting doesn't sound to lame, but how do I access the mysql admin panel? Where do I access it from? I just read about it on the mySQL forum site and thought that it might enable me to fix a problem that I have connecting to phpMyAdmin which for some reason won't let me connect to the mysql server.
View Replies !
Privileges
My .net application connects to MySQL database. A developer created this MySQL database and few tables. Now when I try to create another table for my application it is giving me this error "ERROR 1142 (42000): CREATE command denied to user 'username'@'localhost' for table 'tablename'." Even i tried to grant all the privileges to my user name using the below command "GRANT ALL ON dbname.* TO 'username'@'localhost'; but still iam getting the following error "ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'dbname'" Even i tried to create a new database but still i am getting an error.
View Replies !
SQL Administrator
what do I put in the STORED CONNECTION and SERVER HOST box? I'm assuming SERVER HOST would be the host of my website, but I'm not sure. Another question, is SQL Administrator the continuation of MyCC?
View Replies !
Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database. I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.
View Replies !
Database Privileges
I was wondering if there is a way to prevent useres from creating databases. The scenario is for a web hosting environment where I would like to let users only use their pre-defined database and not be able to create any additional database (e.g. via phpmyadmin).
View Replies !
Setting Up Privileges
if I can restrict a user from a single table. I want him to be able to create,alter,delete all the tables but one, which I want him not to delete it, not to update it not to create it.Just to use it. Can I do it? As long as I have read there is only the way to give credentials for all the objects of the database.
View Replies !
Mysql-administrator
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk9ListStoreE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk5EntryE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib6ObjectE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk6WidgetE' has different size in shared object, consider re-linking *** glibc detected *** /usr/bin/mysql-administrator-bin: free(): invalid pointer: 0x083ca0e0 *** ======= Backtrace: ========= /lib/libc.so.6[0xb716d911] /lib/libc.so.6(__libc_free+0x84)[0xb716ef84] /usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb72e6e51] /usr/lib/libstdc++.so.6(_ZNSs4_Rep10_M_destroyERKSaIcE+0x1d )[0xb72c2fed] /usr/lib/libstdc++.so.6....................................
View Replies !
Changing Privileges
I need help changing host privileges in mySQL server. I am trying to access mySQL server from a remote computer that doesn't have access rights. The online doc sucks; I can't get anything useful out of it.
View Replies !
GRANT ALL PRIVILEGES ON Db.* .....
Having read, as best I could, the docs at http://www.mysql.com/documentation ..., on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter: mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com'; Query OK, 0 rows affected (0.00 sec) but ... [root@max.here.com]# mysql -h mysql.here.com -u root -pmypass ERROR 1045: Access denied for user: 'root@max.here.com' (Using password: YES) "netstat -lt" on mysql.here.com shows the socket is listening okay. tcp 0 0 *:mysql *:* LISTEN.
View Replies !
Grant Privileges Using Like%
I have to grant privileges for users to use databases that start from spm only. So I used the following syntax: grant all on `spm%`.* to username@'%' identified by 'password'; This works fine. Now I log in as the user and create a database named spmtest. After that if I try to use the database spmtest it gives access denied errors. For ex: mysql> create database spmtest2; Query OK, 1 row affected (0.00 sec) mysql> use database spmtest2; ERROR 1044 (42000): Access denied for user 'username'@'%' to database 'database' Can anyone tell me how can we allow users to create databases and then have full rights to the databases they create.
View Replies !
How To Revoke Privileges
I issued following command; CREATE DATABASE mail; GRANT all privileges on mail.* TO user-1@localhost IDENTIFIED BY 'pass1' ; GRANT all privileges on mail.* TO user-1@127.0.0.1 IDENTIFIED BY 'pass1' ; Now I need to revoke user-1's prvileges assigning it to user-2. How can I make it?
View Replies !
Administrator Backup
i want to do a database driven website. just did the installation and dabbled with php and the tables. i m using the MySQL Administrator and MySQL Query Browser tools. i don't understand the difference between InnoDB tables and MyISAM tables. which one should i use? i did 2 test tables. both are InnoDB. if i should use MyISAM tables, will editing them as MyISAM tables in MySQL Administrator cause any problems? also about the backup of the database .. which option should i use in the MySQL Administrator? (i picked the InnoDB online option). also if i lose my data, how do i restore it using MySQL Administrator tool?
View Replies !
None Of Users Privileges
I have no privileges anymore to create a database or view privileges and users. Does somebody know how I can add a user or give my root all privileges again?
View Replies !
Users And Privileges
I just installed mysql and was testing to see if i could setup privileges, now I am logged in as root using the mysql console and wanted to create a user and also give them some privileges.. I am using mysql> GRANT SELECT,INSERT,UPDATE -> ON *.* -> TO bro@localhost -> IDENTIFIED BY 'bobo'; mysql doesn`t give me an error or anything so i figured that it accepted it, but when i try to login using this new user it seems as if its now there. now i used phpMyAdmin to login using root then went to look at privileges and I donb`t see the new user anywhere.. I guess i did something wrong somewhere, any ideas on what it was? abit lost as im new and just following an ebook on this stuff
View Replies !
SQL Administrator Error
I'm new to mySQL, i downloaded mySQL administrator from the mySQL site, connected to mySQL server and when i tried to add a table to my database i got the following error and the program shut down. A mySQL error was encountered. This message is: Error while fetching Schema Table Status. The following error occured: Lost connection to mySQL server during query (2013)
View Replies !
|
TRACKER
