MySQL gets installed with root user by default, root user can administer every mysql database installed in the system. Question is how to create a new user that will not be able to administer all the databases in the system the way as root user is? Can it be done using webmin?
View 7 RepliesHow do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedCode:
#suse's /etc/fstab
/dev/sdb1 /windows/FAT vfat users,uid=1000,gid=100,rw,utf8=true
[code]....
I'm running OpenSuse 11.2. I've got it running mostly the way I want and it connects to my wireless internet no problem. I have a external hard-drive on my Windows machine setup as a share folder. I can mount the drive with:
Code:
mount //10.13.23.2/D /home/james/mnt/win However when I do mount like this it doesn't give my any read/write privliages on the drive. Also on a slightly different issue but still mounting related I have my HDD partitioned into four main drives (not including swap etc). They are my Windows drive, a seperate storage partition formatted for Windows, my main linux drive and a seperate parition for linux storage.
I want to have my Windows drive, my Windows storage drive and my linux storage drive all mounted on boot. I tried adding these to fstab, and they mount fine but again I have no read/write permissions. My fstab looks like this:
Code:
/dev/disk/by-id/ata-WDC_WD2500BEVT-35ZCT0_WD-WXE908AE4273-part5 swap swap defaults 0 0
/dev/disk/by-id/ata-WDC_WD2500BEVT-35ZCT0_WD-WXE908AE4273-part6 / ext4
[code]....
Lastly I would like my Windows Share drive to mount on boot but I have been advised that I would need to write a shell script for this, to do network checks as obviously I won't always be connecting to my network.
I want to create a user on my opensuse 11.4 computer, for the sole purpuse of using it to access network shared data (eg samba, nfs, etc). This user must be in the "Users" group, but it must NOT be able to login directly on the computer, i dont want him to show up on the GDM users list at logon, he must not be able to login to a terminal, etc.
How can i add a user like that? must he belong to a specific group?
I'm using an older redhat system (2.6.9-22.ELsmp) here which is running an older mysql (server version: 4.1.12). I don't think that's the source of the problems. I believe that have understood things rightly when I say that the mysql root user is unrelated to the linux root user ... in my case I believe the root user to be the unix user mysql. So when I connect to the server (local host from a local terminal) I use:
Code:
-bash-3.00$ mysql -u mysql -p
and enter a blank password
This gets me on, however I seem unable to do anything like create database or alter privilege. I wonder if its related to my finding no database called mysql?
-bash-3.00$ mysql -u mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11 to server version: 4.1.12
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)
Although I understand that show databases will not show things I have no priv to see. Does this mean my settings for the users are all screwed? How do I rectify this situation? Some other (perhaps) useful information.
Code:
[root ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
So my BASEDIR seems to be nothing like is suggested in the documentation at [URL].
I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
create a user for php/MySQL under ms win environment?
View 1 Replies View RelatedI installed mysql on FC14, but can't successfully create a new user. It lets me go through all the steps without complaint, but then I can't log into mysql as the new user.
Here's what I did.
1) yum install mysql mysql-server
2) service mysqld start ##sets up mysql
3) mysqladmin -u root password myownsecrectpass ##create a root password
3b) mysql -uroot -p; #log in as root, this works fine
4) CREATE DATABASE webdb;
5) CREATE USER 'anewuser'@'%' IDENTIFIED BY 'password123'; ##create anewuser with a passwd
6) GRANT ALL ON webdb.* TO anewuser@'%';
7) FLUSH PRIVILEGES;
Then I log out of mysql as root and try to log in like this
mysql -uanewuser -p
I enter the password and get this error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I'm using dovecot pop3 server in my website. I tried to create a virtual user system with mysql. But it didn't work. Next I tried to debug my work with reading of dovecot log. I enabled logging in it by changing this values in /etc/dovecot/conf.d/10-logging.conf:
Code:
log_path=/var/log/dov
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
After that I tried to login to the pop3 via telnet and it failed as usual. After I checked the log file (/var/log/dov), but it does not contain any information about that failed login. Only there was some information about starting up of dovecot! Does any body know that what is the problem and why dovecot doesn't log that?
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
Need help maintaining permissions across multiple directories. Have Ubuntu 8.04 Hardy Heron. O/S installed, updated and running with no problems.Why is it that my administrator user id doesn't seem to have root permissions to create directories? I am trying to setup hosting 3 separate websites and therefore create 3 separate directories to manage all associated files for the 3 websites. Also, I am attempting to read through the tutorials located at:URL...
View 4 Replies View RelatedI use Suse 11.2. I mounted 5 folders from fstab. 2 of them work but 3 do not. The 3 folders that do not work let me enter them, and they let me see everything. I can even create or delete a folder on them, if I am just browsing with konqueror. The problem is that I have a program that will not read them. It's a program made for my company and apparently it will only read folders that have all of their permissions set to read and write. The program will read the first two because their permissions are set to Owner, Group, and Others, can view and modify content. (The network folders are all windows server 2003 computers). The 3 folders the program will not read are set to Owner can view and modify content, but Group and Others are "can view content" If I try to change those permissions even in root, it tells me that access is denied.
View 9 Replies View Relatedi'm trying to create a database with the mysql that came with the suse installation, my problem is that i can't get mysqladmin to work it spits out this: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! So I'm stuck at square one php info() seems ok with the installation and the installed client connects to my remote DB ok. I checked the server with ps -ef | grep mysqld and I get the following:
2438 2436 0 15:47 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/home/ben/.local/share/akonadi//mysql.conf --datadir=/home/ben/.local/share/akonadi/db_data/ --socket=/home/ben/.local/share/akonadi/socket-linux-ygk7.site/mysql.socket root 6248 6151 0 16:01 pts/0 00:00:00 grep mysqld
Which doesn't really mean a lot to me but looks ok, anyway my question boils down to does anyone have any obvious ideas of what I'm doing wrong or is, as others have hinted, suse's mysql installation is broken?
I recently got a new external drive and backed all my files up on the new external: movies, music, docs, etc. Now all my files have permission rights to the root only. I was able to change this by open up nautilis from a terminal in root and change the permission on the whole drive to my current user so I can access the files, copy & delete the files. I wanted to change some music file information in Kynamo this morning and was not able to since all the individual files still belong to the root. How can I change this permission issue without having to change each individual file?
View 8 Replies View RelatedI cannot see what the problem is here. I have installed MySQL 5.1.36 via YaST on my openSUSE 11.2 (32-bit) system.I can log in as root. I can "create user MY_user identified by 'my_passwd';" and a new user is created. But I cannot log in to the database using that new user name. I keep getting the message:
Code:
> mysql -b -u MY_user -p
Enter password:
[code]....
Prelude: OpenSUSE 11.2 (2.6.31.8-0.1-desktop), installed Novell client 2.0 SP2 (novell-client-2.0-sp2-sle11-i586.iso).
I found that if any usual user is logged into a NDS-tree, then _local_ root has full access to user's network shares, including the user's home directory located on remote Netware-server. Is it by design or
have I missed something? Nevertheless in windows local admin has no access to network resources mounted of any other user. If you runas shell (as admin) then admin in principle can't "see" network shares which were mounted (connected) by other users - they are accessible ("visible") per session.
Take a physical user FRED. FRED is a linux user ( known by linux on his laptop ) FRED is a Samba user ( Known by samba on the samba pdc server ) When he logs locally (with username/password) on its standalone laptop (with no network), he is known as FRED:user. He access his data in /home/FRED/. When he logs through samba (with username/password) on the domain MY_DOM, he is known as MY_DOMFRED:MY_DOMdomain user. He access his data in /home/MY_DOM/FRED/. ) Is it possible that the human FRED has only one repository and have full access to its repository regardless of how it was connected. If yes, how to do it
2) If not, Is it possible that the human FRED has full access to /home/FRED/.............. and /home/MY_DOM/FRED/.
I want to set samba to act as domain controller PDC.Is it possible to create user profil in samba with rights to change network settings but not install software, create users.Something like network admin that is like normal user but he is able change network settings.
View 1 Replies View Relatedcreate a profile settings and network drive can be mapped automatically when user login to the (like Domain and active user profile on windows environment) Ubuntu systems?
View 1 Replies View RelatedI'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
I'm mounting a cifs share via fstab, and using both the uid and gid for the permissions when mounted (I did try with just gid set too..) My user account is part of the 'users' group.
gid=users; I get read only
uid=nobody, gid=users; read only
uid=veehexx, gid=users; RW access.
Why is that? surely if permissions are set to use groups rather than users, then it should work. How do I get around this? All my knowledge is based in the Microsoft camp - if a user is in a group, then you can assign that group to a resource and it will work.
I have four PCs in my house that are running opensuse 11.2 and I want to create a home network to share files, scanner and printer.
View 4 Replies View RelatedI have openSUSE 11.2 installed and i need to create a gateway server that allows virtual private network connections. I want to play with my friends some lan games, but we are in different networks, so i want to create this gateway server so we can connect with VPN clients to this server and play freely.
View 7 Replies View RelatedI'm on opensuse 11.4 (11.3 won't work with my monitor).
My computer gets internet through wireless and I want to share that internet through its ethernet port. So far I've tried using Knetworkmanager to create a network bridge between my wireless and wired connections. I created a new wired connection and shared it using the ip address settings. I was able to get both connections active, but the device hooked up via ethernet had no internet connectivity.
I also tried this command:
echo 1 > /proc/sys/net/ipv4/ip_forward
but another test resulted in the same fashion (no internet on wired). I believe anything I add to /proc should have an immediate effect, correct?
how to create network policy and system policy in opensuse11.4 and domain policies also???
View 1 Replies View RelatedI just performed a fresh installation of openSUSE 11.3 and ISPConfig 3 on my server. I read through the article "The Perfect Server - openSUSE 11.3 x86_64 [ISPConfig 3]" and followed the instructions closely. Everything went smoothly.
I went into ISPConfig 3 and set up a DNS zone, email mailbox, FTP client, and website all for a client I created, hoping to use the client as the main account for a web site I want to host on my server. After I finished with this, I logged onto the server through FileZilla using my newly created client's information. It took me to the "main directory" with the folders cgi-bin, log, ssl, tmp, and web. When I open "web" I see an html file named "index.html."
I tried loading a mock website into the folder, also with an index.html file, and the files transferred over properly except the mock index.html file. The program changed the name to index.html.1. I tried to delete the original index.html file but was not allowed to. I then tried to rename it to something other than index.html and kept receiving a 550 Rename/move failure message. Can anyone point me in the right direction or help me resolve this issue?
I'm thinking perhaps I don't have the right permissions with the client to rename files, but since that's the account I want as the "owner" of this web site, I need to change the permissions so I can. I tried changing the ISPConfig 3 "Limits" for the account to SSH-Chroot Options "NONE" thinking that might be the issue.
i m not able to create new user account to my new install of 11.2 don't know whether it occured due to update problem or some installation failure. when creation a new profile through yast it gives a warning sub-domain not started and quits however a new user get added through cli but with no profile of its own. that user cant log into gui enviroment and when he/she logs through cli it automatically tranfers it profile to "/"(i.e root) i m using kde4.3
View 9 Replies View RelatedIf I create a user with Yast using ldap than at some later point delete that users ( also using Yast ) I cannot recreate a user of the same name until I have rebooted the machine, which seems a bit excessive ! Closing and reopening Yast doesn't work, it still thinks the users exists. Even though it doesn't appear in the Yast and if you look in the ldap browser it is gone. Is there something else that need restarting ( other than the whole box )
View 1 Replies View Related